SSRS Matrix Coulmn Group pagebreak not working

B_Khan 1 Reputation point
2022-02-03T17:04:55.273+00:00

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
Transact-SQL
Transact-SQL
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
    2022-02-04T07:51:57.727+00:00

    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.

    0 comments No comments

  2. B_Khan 1 Reputation point
    2022-02-16T18:12:19.93+00:00

    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