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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s