Monday 23 January 2017

MS CRM Online - #SSRSTip1 - SSRS Fetchxml Data Source and Connection String

Hello All,

Lets learn a quick tip regarding fetch based SSRS report development. With CRM online, FetchXml is the primary option to retrieve data from CRM.

This tip deals with Fetch data source connection string and best ways to avoid issues with connection string.

While developing a new Fetch based report, the fetchxml datasource connection string should be the server URL. In most cases, with server URL the report works as expected.

Ex: https://contoso.crm.dynamics.com



But at times while debugging from local, we may face weird issues like
  • No data retrieved for a valid query
  • Field not available error for a valid query
  • Entity not available error for a valid query
Cause:
Sometimes these fetch data sources may point to some first instance in the group of organizations instead of the one specified in URL.

Fix:
Use the organization unique name with connection string which will fix the issue.

The organization unique name will be available in Developer resources under Settings => Customization

In the following sample, contoso is my org unique name
Ex: https://contoso.crm.dynamics.com;contoso

Hope this helps!

4 comments:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MICROSOFT DYNAMICS CRM kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on MICROSOFT DYNAMICS CRM We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/

    ReplyDelete
  2. Fabulous! Greate post, this blog is really helpful for Microsoft CRM developer I really appriciate this blog, you target every important information in this blog. Thank you so much for sharing this with us.

    ReplyDelete
  3. Hi, I do believe this is a great website. I stumbledupon it 😉 I’m going to revisit once again since
    saas cloud services

    ReplyDelete