SSRS MS Dynamic Fetch Query Limitation

20 views Asked by At

I am working on an SSRS Report that will retrieve records based on a fetch query. You can find my fetch xml query in the image below:

Fetch XML Query Picture

The fetch query in the image above has an error in the fetch tag and is not throwing any records, however if I set the count to 5000 and page to 1 it will retrieve 5000. Shown in the image below:

Sample report image

I tried playing around with page and count, however this is the maximum that I can retrieve. Using fetch xml builder in XRM toolbox I can retrieve almost 26,000 records but when I used the query on SSRS I could only retrieve a maximum of 5000 records.

Any information and assistance will be greatly appreciated! Thank you!

0

There are 0 answers