SSRS Matrix Coulmn Group pagebreak not working

B_Khan 1 Reputation point

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.171103-capture.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,318 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,735 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,524 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,881 Reputation points

    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




    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.

    0 comments No comments

  2. B_Khan 1 Reputation point

    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).

    0 comments No comments