How to export get each separate report on "Page Break" in SSRS report

Arjunarao Juneboyina 1 Reputation point

Hi All,

I have a SSRS "Employee Details Report" as Shown in below.

Page break applied on DEPTNO and we have 3 values 10,20,30.

Is it a way to generate for each page break? (As per my data I am expecting 3 report outputs like 3 PDFs or 3 Excel files )

Kindly advise.




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,103 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Arjunarao Juneboyina 1 Reputation point
    No comments

  2. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee

    Hi @Arjunarao Juneboyina ,
    Take exporting Excel as an example. I did a test locally. You could refer to the following operations:
    1.First of all, let us add grouping (group by "DEPTNO" in your case), We have enabled the Add group header option so that we can use it to repeat the column headers later.

    2.Next is to include the page break to the included groups. To do that, go to the properties of the groups from the following option.

    In the Page Breaks option, choose the Between each instance of a group as shown in the below image.

    3.Now we need to provide the sheet name for when exporting to the Multiple sheets of Excel in SSRS.
    Go to the properties of the group and go to Group -> PageName as shown in the below screenshot.

    Since the sheet name is dynamic, it has to be an Expression. In the expression property page, you need to provide the name of the sheet by combining the dataset fields as shown in below (according to your case): Fields!DEPTNO. Value & "Sales"
    4. Export to Excel format and view:
    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.