I have a report in SSRS 2008 R2. This report consists of a single table containing several levels of grouping. If the client asks to see all the details, I want to split the page at the second level of the table grouping. If only the summary data is requested, I do not want the page to be interrupted, as this will cause unnecessary paging. How can I conditionally control page breaks at the group level in a table?
The summary data is calculated and returned differently from sql, so I don’t want to hide the rows, just turn the page spread on or off.
source
share