views:

2120

answers:

2
+1  A: 

The solution to this issue is the rectangle component. Based on your image, I am assuming that your report has a table that is grouped on location. For each location you are reporting on Number and Value. Column 1 has the location name, Column 2 is the label and Column 3 is the field values.

Create a new table (TABLE A). Set the table to group on Location. In the group footer, add a rectangle (RECTANGLE). Set the Keep Contents Together property of the rectangle to TRUE.

Add a table to the area of the rectangle (TABLE B). Do not add a grouping to TABLE B. Add to the details row of this table Column 1, Column 2, and Column 3 formatted as it is in the existing report.

When the report renders, each group will be kept together and the rectangle will force page breaks between the groupings.

The solution above works for SSRS 2008. The solution below is similar and works for SSRS 2005.

Create a new table (TABLE A). Set the table to group on Location. In the group header or footer add a table (TABLE B). Do not add a grouping to TABLE B. Add to the details row of this table Column 1, Column 2, and Column 3 formatted as it is in the existing report. On the TABLE B use the Fir table on one page if possible option.

StrateSQL
I cannot find a "Keep contents together" property on the rectangle? I'm using SSRS 2005.
Charlie
I dont think this answer is correct. There's a Keep together property on a table, but not a rectangle, but you cannot nest tables so this won't work.
Charlie
I've edited the answer after playing with this in SSRS 2005 a bit. There are a few feature changes between the two. Be sure the second table is added to the header or footer. The detail area won't work.
StrateSQL
A: 

Make sure the interactive size and the page size are the same. You also have to set the margins so that the print version prints properly.

Zaid Zawaideh