question

JeffSchwartz-4808 avatar image
0 Votes"
JeffSchwartz-4808 asked AmeliaGu-msft commented

Can SSRS burst out reports by group

Say I had a department number and I wanted to burst this report out to every manager and ONLY show them their departments data. Can I do this out of the box with SSRS?

sql-server-reporting-services
· 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.

Hi JeffSchwartz-4808,

Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

If you pass the department number as parameter to the report, then you can filter the data for the report base on that parameter.

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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi JeffSchwartz-4808,

Welcome to Microsoft Q&A.
You can add "manager name" as a parameter to the report and make the report show only the direct departments of the manager passed to the parameter. Then create a subscription for each manager and pass their name to the "manager name" parameter.

Best Regards,
Amelia


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.

AurangzaibMughal-5380 avatar image
0 Votes"
AurangzaibMughal-5380 answered

Yes you can do this by passing a parameter with hidden visibility and then go to properties and select default value and then choose userid from built-in fields


121866-image.png



image.png (14.3 KiB)
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.