![]() The sky is the limit in terms of what you can do with this. Select = Cast(cmcEMailAddress as VarChar(max)) from Contacts where OrganizationID = 'LockHeed' and name = 'ABR'ĮXEC = 'ERP Email = 'Shortage = 'Please see attachment for shortages.' = 'D:\ERPSQLPro\TempReportData\SupplierForecastbyPart.pdf' This allows the end user to update this at any time and all future reports will go to the correct address. The dynamically gets the e-mail address this should be going to. Set = 'D:\ERPSQLPro\TempReportData\CrystalReportsNinja.exe -U SA -P ERPSQLProsales -S ERP_SQL_Pro - D ERPSQLPro_ERPSQLPro -F D:\ERPSQLPro\Reports\Supplier_Parts_Forecast.rpt -O D:\ERPSQLPro\TempReportData\SupplierForecastbyPart.pdf -E pdf -a "Filter_PRODUCTIONSTARTDATE:' + + '" -a "DropDown_1_GroupBy:2" -a "CheckboxGroup_1_PageBreak:False" -a "CheckboxGroup_1_SortBy:False" -a "UserID:ERP_Auto" -a "Props_DS_xadDescription:ERP_Auto" -a "Filter_SupplierOrganizationID:LockHeed"'Įxec Master.xp_CmdShell Example of the code to create the e-mail and send it out. The formula automatically picks the second week out from the date the report is run, formats it to suit, and applies it to a parameter in Crystal so it is a rolling report. An example of the job step below to create the report using CrystalReportsNinja. In almost all cases, you can convert these to a datasource that is filtered as expected far easier than you can create a new report allowing you to leverage all the time you've spent creating that perfect report instead of starting over. Some have HTML / SQL / VBS code that creates recordsets used as the data source for the reports that only works in their system. Some have parameters that won't run outside of their system. What do I mean by that? Different ERP systems have proprietary stuff that runs their reports. Modify the reports so that they run outside of your ERP system as expected.Links to both - Crystal Reports Ninja DataLink Viewer Otherwise you need to set the actual database in the report for it to work. ($25) The Datalink Viewer has the advantage in that you can use it to change databases dynamically and some additional functionality. Get either a copy of Crystal Reports Ninja (free) or the Datalink Viewer.To do this, you'll need to follow the steps below. It doesn't have anything to do with your ERP system at that point and any licensing concerns go out the window. Let's put it all together! Using an SQL Server job you can have a 3rd party tool costing about $25 run a Crystal Report and e-mail it. Thank you for reading my blog.If you look through some of the stuff I've posted, there's been stuff on how to e-mail alerts out of SQL Server, how to use tools outside of your ERP system to run reports and some stuff on how to convert some report formats. Crashes often, unfortunately in the latest releasesĭownload Sequel Pro Thank you for reading, and let's connect!.The tool itself is one of the best UI's for MySQL I've personally seen. Sequel Pro used to be my favorite MySQL client for Mac, however, they seem to have a fair amount of crashes lately. I really like the tool however, it should have been a free tool. Very Mac like interface and clear to understand how it works and what it does. ![]() For me, however, it feels a bit too much. This tool is complete and has many cool features.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |