How do I manage page breaks between tablixes in Paginated reports?

Nimisha Vernekar 126 Reputation points

I have a report which consists of three tablixes, the issue that I am currently facing is:

  1. The header of second tablix is visible on the same page after the end of first tablix. And it is just the headers and no rows, the actual tablix including both header and records start from next page. I want to get rid of the header of the second tablix from the previous page. I tried using the Tablix properties that allows to add a page break before/after. This gives rise to my second issue.
  2. It definitely removes the trailing header of second tablixes but adds a blank page in between 2 tablixes. I don't want blank pages in my report.![174622-blankpage.png][2]
  3. I have tried playing around the options in advanced mode of column groups, nothing seems to work. [2]: /api/attachments/174622-blankpage.png?platform=QnA
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,555 questions
0 comments No comments
{count} votes

1 answer

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

    Hi @Nimisha Vernekar

    Page breaks can be added to report items such as a table, matrix, list, chart, gauge, or image. You can also add page breaks to groups in a table, matrix, or list. Page breaks can be added before, after, and between groups. Page breaks between groups are not added to the report by default.

    Suppose you want to page three Tablix, just select the second Tablix, and check "Add a page break before" and "Add a page break after"at the same time in Tablix Properties .


    If you want to hide the second tablix and paginate the first and third tablix. You just need to set the "Visibility" option in the Tablix Properties of the second Tablix to "Hide", and then check "Add a page break before" in the properties of the third Tablix.


    If I misunderstand what you mean, please feel free to correct me.
    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.