Creating complex SSRS reports for Microsoft Dynamics GP without 're-inventing the wheel'

May 16 2013

Creating datasets for Dynamics GP reports can be a daunting task that requires extensive knowledge of the GP database structure.   But what if you could use the same stored procedures and views that GP utilizes when it retrieves this data?   With the use of the often overlooked SQL Server Profiler tool within Microsoft SQL Server Management Studio, you can do just that.

Read on for more details and a demonstration of the technique.

About W. Mike

Mike brings strong data integration and conversion skills to Computeration.  His "can do" attitude gets data integrated into new systems quickly and cleanly.  He has delved into multiple legacy accounting products to retrieve data, utilizing Microsoft Access, Excel, Visual Basic, and SQL tools to convert and integrate data.

Mike utilizes his technical skills to develop efficient and economical customizations for clients.  He works with SharePoint, Business Portal, Web Services, SQL Reporting Services, and other legacy databases and reporting technologies. 

Mike's goal is to aid clients in their day-to-day processes.  His proficiency with the tables and fields in Dynamics, along with the process flows within all the modules, facilitates his ability to quickly and efficiently complete the migration of data.

More about W. Mike