This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 84%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
Hi All,
Please find the report https://drive.google.com/file/d/1UfZlwpfs0UwIkLdIW3E1obZFiFMuundK/view?usp=sharing
Hi @Arjun ,
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,
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.
Refer to the following gif file：
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.
Thank you so much for your solution.
I want to generate the separate excel output report for DEPTNO 10,20,30.
Is there a way for this? Through script or through SSRS options?
Hi @Arjun ,
First, you need to group "DEPTNO", select the "DEPTNO" detail row to add a row group, group by "DEPTNO", which is consistent with the steps in the above scheme.
I'm not sure if you want to save the reports to separate Excel files, as shown in the figure below:
If this is the case, I suggest you follow the above steps to export the report and save it as a separate file.
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.
Hi @Joyzhao-MSFT ,
I want to save the reports to separate Excel files
Hi @Arjun ,
As far as I know, SSRS cannot be exported as three separate Excel files. If you really need it, it is recommended that you save the exported Excel file as three separate Excel files. Another method is to create a subscription by setting parameters and send the report via email.
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.