Posts

Showing posts from June, 2014

Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports

Image
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. -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons -- Attribution-NonCommercial-ShareAlike 3.0 Generic license. declare @objectId uniqueidentifier; declare @rptContent varbinary; declare @reportName varchar(255); -- custom report name information set @reportName = 'Contract Deferred Revenue Detail Report'; select @rptContent = Content from ReportServer.dbo.Catalog where Name = @reportName; -- setup a new GUID

Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports

Image
Using Microsoft Dynamics GP Business Intelligence deployment utility to deploy custom SSRS reports - Part 1 I was in Johannesburg, South Africa this past week visiting a customer with the distinct challenge of working with an extensive number of company databases - one for each company division. While I was there to provide Microsoft Dexterity training , undoubtedly other topics of conversations tend to surface at various points. In this occasion, I was the one doing some learning as the customer pointed me to a method they devised to deploy SQL Reporting Services Reports (SSRS) to multiple companies by using the standard Microsoft Dynamics GP Reporting Tools Setup window. The company have over 50 custom reports of all kind which can take more than a day to deploy if they were to do so manually, once a new division database is rolled out. Reporting Tools Setup window Under their current situation, the customer simply want to click the Deploy Reports button on the setup wind