Share via

SSRS Report - adding page break at the end of the subreport

DaralisP 1 Reputation point
2022-02-17T04:07:20.03+00:00

Hello Iam trying to add a page break at the end of the subreport when the totalpages of the subreport is odd. Is there anyway to do so.
Thank you so much.
~Dar

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.
2,848 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-02-17T09:33:54.657+00:00

    Hi @DaralisP ,
    Are you referring to add a page break only when the number of subreport pages is singular? For the page break behavior in the subreport, we usually add a rectangle to set the page break for the rectangle.
    I think using custom code about page numbers combined with IIF conditional expressions should do the trick.
    I am not good at Custom Code, you could refer to the link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4dc33cfa-c9e9-4be6-bf08-166f1a9238bb/ssrs-report-controlling-even-page-numbers-per-group-for-printing-purposes?forum=sqlreportingservices
    If I misunderstand what you mean, please feel free to correct me.
    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.