Page Break within Group SSRS

Ben Fryman 1 Reputation point
2022-01-21T19:59:11.35+00:00

I have a sub report within my Main report in SSRS, and the sub report is within a group inside the Main Report. Right now the Main report page breaks appropriatley between each instance, but within that group I want the sub report to page break as well for each iteration. Right now the report does it fine on its own, but I read that those settings don't get carried over into a sub report. So my question is, Is this possible/ how do I do this?

I've tried the rectangle page break, and many other settings within SSRS and can't get this to work. Any help would be appreciated.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,631 Reputation points
    2022-01-24T06:55:26.983+00:00

    Hi @Ben Fryman ,
    Insert a rectangle below the subreport, and set "PageBreak" in the rectangle property to "End". At this time, the rectangle will force the grouping of the subreport to be paged (I also performed the "Page Break" operation in the subreport's group properties) , it worked in my tests.
    167640-03.jpg
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.