Using SQL Views for Reporting Data in Microsoft Dynamics GP and SL

By |September 26th, 2014|Blog, Microsoft Dynamics GP, Microsoft Dynamics SL, SSRS|

Microsoft Dynamics GP and Microsoft Dynamics SL ERP solutions both provide predefined SQL Views that can be used for simplifying your report development. A SQL “View” is essentially a virtual table or predefined SQL “Select” statement that is stored in the database as an object. Some of the benefits of using a SQL View in [...]

Dynamic Data Source in Microsoft SQL Server Reporting Services for Dynamics GP

By |August 11th, 2014|Blog, Microsoft Dynamics GP, SSRS|

Microsoft SQL Server Reporting Services (SSRS) is a great tool for writing custom reports for Microsoft Dynamics GP users. One issue that caused a little frustration was having to create multiple reports to accommodate different databases in GP. When a customer would request a change to a report, I would have to modify the report [...]