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
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!
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
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!
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
ReplyDeleteMaxMunus 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/
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.
ReplyDeleteThanks Marry!
DeleteHi, I do believe this is a great website. I stumbledupon it 😉 I’m going to revisit once again since
ReplyDeletesaas cloud services