FetchXML Report Record Count Limits Demystified
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. Special thanks to my good friends at the Microsoft CRM team for showing me the light.