SSRS Stop group in tablix being split across print

问题:

I have a tablix in SQL REPORTS (SSRS) that has many grouped items.

It fits roughly 3.5 groupped item per page when printnig, however I dont want the groups to be split up over the 2 pages, I want a pagebreak to happen whenever the group needs to be split.

I dont want to have it 1 group per page either, I know there is an option for that.

回答1:

At the bottom of the report builder, you will see two boxes, Row Groups and Column Groups. Select the Column Groups drop down, click "Advanced Mode" and then in Row groups highlight "Details". In Properties under the "Other" section, select "True" for Keep Together. and save. This should work. Note: I know this is old hope this helps people starting out though.

回答2:

Probably the best place to start is the group-level KeepTogether property.

Indicates whether to keep all sections of the data region together on one page.

回答3:

I have just worked through 3 similar reports that were all suffering this issue.

It was only when I marked the group row AND the detail row to get the report to force a page break and keep the pages together.

Interestingly, I can then set the DETAIL BACK to false and the report still functions correctly. I have no explanation as to why, but this was repeatable.

I am using SQL Server 2016 Report Builder (the red one)

回答4:

Modifying the property Other -> KeepTogether of the outermost row group desired to keep within a single page worked for me using Report Builder 3.

My KeepTogether values for each Row Group

Notice in my example, KeepTogether is false for table1_Group1. I don't want to keep my entire dataset together. Instead I want to keep only individual groupings of that dataset together.

In order to see the Properties panel, enable the Properties checkbox under the Show/Hide section of the View tab of the Ribbon.

My View settings

回答5:

I tried all options about that. When I have a more difficult group, it sometimes happens, that the group will be split across pages. Even though setting "Keep Together" property to True.

My solution is:

• don't use multiple rows
• use one row with rectangle
• to rectangle import TextBoxes and fill them with expression "=Fields!Column.Value"