SSRS Matrix Coulmn Group pagebreak not working

Question

I have a report where I'm using row limiting row group expression as =ceiling(rownumber(nothing) / 5) and then for column group I'm using =ceiling(rownumber(nothing) mod 5) also selecting page break options between each instance of the group.
Desired output would be 5 data points in first row and then next 5 in the second but my column group is bringing the next page data as well.
Please refer to attached snapshot. I don't want to get the highlighted portion.

Answer 1

Hi @B_Khan ,

Do you mean that you want to make 5rows and 5 columns per page on this report?

As far as I known, to limit no of columns in SSRS matrix report, we will need to use custom code.

Only with ceiling(rownumber(nothing) mod 5) will not work.

Reference: limit-no-of-columns-in-ssrs-matrix-report

display-a-fixed-number-of-rows-per-page-for-an-ssrs-report

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hey Zoe,

If you look at the screenshot that's how my report exports at this moment. I just need two rows of data per page 5 records in top row and 5 in bottom. I'm doing the same thing that your article mentions only thing is I don't add page break after applying row group ceiling expression and then the next column group becomes the bottom row with following expression =ceiling(row number(nothing) mod 5).