You’re offline. This is a read only version of the page.
25
We have a requirement to implement a Report in CRM Online using FetchXML.
We were able to successfully create the FetchXML query, but when the output of the FetchXML query exceeds 5000 records, then Report is not working as expected.
Is there a way to retrieve more than 5000 records from FetchXML Query (to be used in Reports) in CRM Online ?
*This post is locked for comments
HI Santhosh,
Another completely different option if you have a lot of this type of reporting needed through SSRS you might look at the replication of your database to Azure SQL and then utilize standard SSRS
technet.microsoft.com/.../mt744592.aspx
msdn.microsoft.com/.../ff519560.aspx
Just another thought that might be overkill :)
Thanks,
Thanks for your response Prashant.
As mentioned in my initial post, we need to display more than 5000 records in a Report (which is hosted on CRM Online).
As we cant use custom code in CRM Online Reports, we were looking for any possible workarounds.
Hi Santhosh,
You can use "FetchXML aggregation".
When you perform an aggregation, the maximum number that will participate in the aggregation will be 50,000 records.
http://us.hitachi-solutions.com/blog/2013/09/10/leveraging-aggregate-fetch-calls/
https://msdn.microsoft.com/en-us/library/gg309565.aspx
But if you need this for plugin/batch programs, i would suggest to use "paging cookies" om the fetch XML.
Hi Santhosh,
you will have to use paging cookie, if you want users to be able to see more than 5000 records. it can be achieved by both fetchxml and LINQ. Here's a URL which might help:
https://msdn.microsoft.com/en-us/library/gg328046.aspx?f=255&MSPPError=-2147217396
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (