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

Arjunarao Juneboyina 1 Reputation point
2021-04-15T22:58:32.537+00:00

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.

88288-dept-10.jpg

88385-dept-20.jpg

88289-dept-30.jpg

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
    2021-04-15T23:10:27.47+00:00
    No comments

  2. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2021-04-16T03:03:11.66+00:00

    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.
    88429-07.jpg

    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.
    88427-01.jpg

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

    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.
    88404-03.jpg

    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"
    88348-04.jpg
    4. Export to Excel format and view:
    88390-05.jpg
    88481-06.jpg
    Best Regards,
    Joy


    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.