News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum How to break FetchXML ...

Dynamics 365 general forum

How to break FetchXML query in SSRS into 25 rows tables

(0) Share

Report

Report

Posted on by DonSwansonSr2

10

Good evening everyone,

I have an interesting question regarding FetchXML and SSRS. Effectively, I need to have tables with 25 records per page and on the last page, blank rows to make sure it is still 25 rows.

My problem is that my query must be FetchXML so I am unsure of how to do this. My original thought was sub-reports with 25 row limits but I am not sure how I was basically do 25 row pagination so I thought I would see if anyone had any ideas.

Again, it would go like this with say 60 records returned from the FetchXML query:

Page 1 - 25 rows Page 2 - the next 25 rows Page 3 - the next 10 rows, and 15 blank rows

Thank you!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Drew Poggemann 4 on at

Like (0)

Report

RE: How to break FetchXML query in SSRS into 25 rows tables

Hi Don,

There is probably a much better way to do this but here is a thought ;)

What about doing a join to another table / entity that has basically blank row except for a key field that you would not fetch. You could have say 1000 of these records and do left outer join that would bring back all the fields from your primary entity as part of the result set of the fields from the 2nd entity. Example is tie the two together with a row index or something like that and pull back rows <= [record count from real table] + mod([record count from real table])

I haven't thought through all the details here but this might get you down the right path...

Thanks,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,407 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans