Home > CRM, Javista, Microsoft, Microsoft Dynamics, Reports > Use Shared Data Source for custom Microsoft Dynamics CRM reports

Use Shared Data Source for custom Microsoft Dynamics CRM reports

Meet guest blogger Jim Wang, Microsoft Dynamics CRM MVP. He is a technical consultant working for 2B.net, an UK based consulting company. He has been working on Microsoft Dynamics CRM since version 1.2.

Recently I have been asked to modify some reports. In my current project we have 4 environments (Development, Training, UAT, and Production) and we have custom reports for each environment. The reports for each environment are different because the data source is different. So the deploy administrator complain about numbers of report. They come and ask me if there is a way to have one report for all environments.

So this is how I did it:

If you have a look the CRM reports in report manager, there is a Data Source call: MSCRM_DataSource
I have noticed that actually all CRM reports use this data source, so why can’t I use it for our custom reports? I think it shouldn’t be a problem.

In Visual Studio, open the report project, Add a Shared Data Sources call: MSCRM_DataSource, it is important to keep it as same as CRM’s. The connection string just uses the development environment, e.g.: Data Source=crm;Initial Catalog=org_MSCRM

Once finished, upload the report RDL file using the Report Manager, e.g http://crm/reports.

See how Jim solves this challenge…

Cheers

Jim Wang

Advertisements
  1. May 7, 2013 at 2:06 am

    Hello! I could have sworn I’ve visited this web site before but after browsing through some of the posts I realized it’s new to me.
    Nonetheless, I’m certainly delighted I found it and I’ll be book-marking
    it and checking back regularly!

  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: