Hi All,
Please find the report https://drive.google.com/file/d/1UfZlwpfs0UwIkLdIW3E1obZFiFMuundK/view?usp=sharing
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.