Two report blocks in one report - same group export not working

Question

Hi All,

My SSRS report contains two reports.

1. DEPTNO Salaries
2. DEPTNO Commission

Applied the grouping on DEPT No.

When I export to excel,

I want to see each group of two reports into a sheet.

DEPT10 in 1st page,DEPT20 in 2ndt page,DEPT30 in 3rd page

How to achieve?

Answer 1

Hi @Arjun ,

I want to see each group of two reports into a sheet.

Here you only need to select "DEPTNO", right click-add parent group-row group-Group by "DEPTNO"

After that , follow the steps of your previous case link: https://learn.microsoft.com/en-us/answers/questions/359414/how-to-export-get-each-separate-report-on-34page-b.html?childToView=361743#comment-361743
I have already given the direction to resolve the issue, you need to try it by yourself.
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.