question

arjunarao avatar image
0 Votes"
arjunarao asked arjunarao commented

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

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?
88621-capture.jpg


sql-server-reporting-services
capture.jpg (20.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @arjunarao ,

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://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.