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 your report writing effortTable relationships in a multi-table query can be defined in the View, including the type of join (inner, outer, full) that is being employed. If you don’t fully understand how to create the relationships, you can frequently get a more technical resource to create a View for you, which you can then consume in your report. Obscure field and table names can be changed to more meaningful terms. … [Read more...] about Using SQL Views for Reporting Data in Microsoft Dynamics GP and SL
Dynamic Data Source in Microsoft SQL Server Reporting Services for Dynamics GP
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 and then redeploy the report three or four times. Finally, I decided, “Why not make the data source dynamic?”After a little searching on the web, I found a way to base the data source connection on a parameter. My first step was to create a parameter to allow the user to select the company they would like to run the report against. This is easy enough to accomplish by creating a dataset based on the following … [Read more...] about Dynamic Data Source in Microsoft SQL Server Reporting Services for Dynamics GP
