SSRS - Prevent pagebreak in the middle of a row group

Question

I have an SSRS report that gets exported to PDF and then printed on to paper. The problem I am having is that I am getting page breaks in the middle of a group.

I have MetricGroup - MetricSubGroup and Details. Those are my Row Groups.

I have several different MetricGroups in the report.

I need to make it so that my report will not break in the middle of a MetricGroup.

So right now I get lets say 2 metric groups and half of the 3rd metric group on page 1. Page 2 contains the second half of the 3rd metric group and so on.

I need SSRS to push a metric group to the next page if the metric group does not fit entirely on the current page.

Is this possible to accomplish?

Answer 1

You need to use the KeepTogether option - but bear in mind this is a "best endeavours" process - for instance, you couldn't keep two thousand rows together on one page.

Another approach is to force page breaks and certain parts of the report.