Shared Data Source for reporting

When developing reports for Microsoft Dynamics using SQL connections, it is recommended to use a shared data source so that you can include your reports within a solution and allow them to be promoted across different environments without having to amend the data source.

Microsoft Dynamics provides a Data Source called MSCRM_DataSource which always points to its SQL environment, so if your reports use a shared data source called the same, it doesn’t matter which environment it is installed on, it will be using the correct Data Source for your SQL server.

Shared Data Source in Report Project
Shared Data Source in Report Project

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.