Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports - Part 2
In the previous installment, I outlined a technique to deploy your custom SQL Reporting Services reports using the standard Business Intelligence deployment utility provided by Microsoft Dynamics GP (Administration | Setup | System | Reporting Tools Setup). In this installment, I will provide the scripts needed to update the Microsoft Dynamics GP system database tables, sySrsReports and sySrsReportDataSources, respectively.
A bit about the script...
The first step is to declare a couple variables that will host the report name and actual report definition language (rdl) content for the report. This information can be found in the dbo.Catalog table in the ReportServer database.
Next, we need to create a unique identifier (GUID) value for the report that we need to deploy. With this information, we can proceed to add the SRS report information to the sySrsReports table.
We can then add the data source information to the sySrsReportDataSources table. Keep in mind that there needs to be an entry for each data source listed.
Until next post!
Mariano Gomez, MVP
Intelligent Partnerships, LLC