Need Page Break Only After Group When Next Instance of Group Won't Fit On Same Page (SSRS 2008 R2)
How can I set a page break before the next instance of a group that won't fit on the same page on which it was started?
Now it splits the group instance in the middle of the group. I need all instances to be visible on the page on which they start.
When the group doesn't fit, I need a page break before it so it will start on the next page.
August 11th, 2012 11:17am
Hi CloudNine,
From your description, you want to add page break before an instance of a group if the complete data for this instance cannot be displayed on the page where this instance started. If I have anything misunderstood, please feel free to let me
know.
Based on the scenario, we can add conditional page break to the target group. To do this, we can select the target group in the Grouping Pane, and then set the PageBreak properties for the group from the Properties Pane. For the detailed steps, please see
the answer of the following thread:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4539822d-d671-4974-990f-ddfc70285532/
Please notice that SSRS doesn't provide a function to judge whether a group displays on a single page or expand to multiple pages, so you need to specify the explicit values before which the page break is added.
If you have any questions, please feel free to ask.
Regards,
Mike Yin
TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback
here.Mike Yin
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 15th, 2012 4:13am