Page break in the middle of a matrix

Question

I have a report with a matrix that has 2 level of grouping. That produces 5 detail lines and 1 total line for each upper level group. This may sometimes extend over several pages and when it is rendered as PDF, it ends up breaking in the middle of a group.

I know that I can force a page break for each member of a group but what I'd like is to break after each 4 members of the outer group.

I'd also like to repeat the page heading and table headings on each new page and maybe even add (CONTD) to the end of the Page heading.

Is this possible?

Here's a screen-shot of my report result.

Answer 1

Hi @Nick Ryan ,
Thanks for providing the framework of the report.
Our most common is to add page break in Group Properties after grouping. But this will usually be paged after each item.

The second is to add page breaks to the rectangle, which is obviously not applicable in your report. The last thing I want to say is to group by row.

Unfortunately, SSRS cannot meet your requirement of presenting a page for every four items after grouping. As you said, each item has five detail rows and one Total row after grouping, you could paginate the page according to the number of rows. For a detailed tutorial, you can refer to: Using Groups to Choose the Number of Rows per Page.
But I'm not sure whether this scheme is applicable to your current grouping report. But as far as I know, other than that, there is no other way to achieve your needs.
Similar to the above scheme, you can also use parameters to control the number of rows. For more information, please refer to: Using Parameters to Control the Number of Rows.

About displaying row headers and column headers in multiple pages, it can be achieved by setting RepeatOnNewPage to True, please refer to: Display Row and Column Headers on Multiple Pages (Report Builder and SSRS).
Hope this helps.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
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

With the help of the page Joy directed me to, I've figured out a way to make this work.

In the data-set, I calculate the page that each site should appear on. I add a top level group based on that page number column and then page break for each member.

I had to pull out various elements of sorting and filtering that the tablix does in order to get the page number right so it took me a few attempts but it's now looking good.

I'd still like to know how to get that initial text box to be included on the top of each subsequent page but I can live with is as it is.