Conditional Page breaks at group level in SSRS2008 R2 reports

ssrs-2008 page-break
Roger Scoffield picture Roger Scoffield · Mar 20, 2013 · Viewed 24.2k times · Source

I have a report in SSRS 2008 R2. This report consists of one table containing several grouping levels. If the customer requests to see all the detail them I want a page break at the second grouping level of the table. If only the summary details are requested then I do not want the page break as that will cause unnecessary paging. How can I conditionally control the page break at the group level in a table?

The summary details are calculated and returned differently from the sql so I do not want to hide rows, just turn page break on or off.

Answer

Ian Preston picture Ian Preston · Mar 20, 2013

You can use expression based page breaks, which, depending on your exact table setup, might be useful.

Basically, you set up a parameter to control whether page breaks are applied.

At the Group level, there are Page Break options - set the Page Break property to what you require, then set the Disabled property to be expression based, something like:

=IIf(Parameters!Break.Value, false, true)

enter image description here enter image description here

This means the Page Break will only be applied of the Break parameter is set to true.

Related questions

Inserting a Page break into an SSRS report

I have a report in SSRS that contains 12 subreports. After each subreport, I need to insert a page break so that each subreport starts on a new page and doesn't share pages with the other subreports. Does anyone know how …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More