Tablix Fix Number of row per page without disturbing the components below

JRM 1 Reputation point

We have a requirement to print invoices on pre-printed paper. The number of rows per page should not exceed to 5. Rows beyond 5 should go to the next page. This can be done by grouping, however, it disturbed all of the components below and will push to the next page as well.

Using header and footer is not an option as the components below are also tablix. tablix cannot be added to footer.

Please see below illustration:strong text


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,824 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points

    Hi @JRM ,
    As you said, if you force a page break with the expression =CEILING(RowNumber(Nothing)/5), the tablix below will only appear after the page break ends, not on the first page at the same time as expected.
    In report design, the rule of displaying report information from top to bottom in the data area is followed by default. A feasible way to solve this kind of issue is to create a subreport for each Tablix and display the information of each subreport in a List.
    You can refer to the following video to create the corresponding subreports: SSRS Two Tablix Page Break with Same number of Rows and show in one page.
    Best Regards,

    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