SSRS Stop group in tablix being split across printing pages

reporting-services ssrs-2008 ssrs-tablix ssrs-grouping
michael picture michael · May 29, 2013 · Viewed 22.5k times · Source

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.

Answer

TDavis picture TDavis · Jul 22, 2016

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.

Related questions

Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and …

Read More
How to hide parameter based on another parameter value in SSRS

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can …

Read More
Trying to Add Sub Row Group inside Parent but flush left in the nested cell

What I am trying to do: I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent. So in this case You'd have: Market …

Read More