I was under the impression myself, and have seen it on the web, that there is either a 5,000 or 10,000 record limit for FetchXML reports. This is obviously a big deal when working with CRM 2011 Online. However, I am happy to report that this is a myth, and I have seen the light. Here is a screen shot of a Fetch report I did for an online environment:
When my good friends at Microsoft told me this I had to stop them and say: “It’s on the internet. It HAS to be true.” But the proof is in the pudding.
Now even though there isn’t this record limit, it still begs the question of whether it is appropriate to use reports to return so many records, or perform aggregations in the RDL file with this dataset. Does one really want to work with 893 pages worth of data? My recommendation is if it gets to that point, one should consider using rollup entities or in certain cases, using a data warehouse. Obviously every situation is different, and there are always trade-offs.
If you want our expertise in determining the best solutions, please contact us at 864.250.2170 or info@customereffective.com. Special thanks to my good friends at the Microsoft CRM team for showing me the light.
Post by: James Diamond,
Hi,
I have tried FetchXml based report in my on-premise development machine for Account entity by specifying the count attribute as 10000 in fetch query but still only 5000 records were displayed on report. Please let me know how did you fetch more than 5000 record in your report?