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?
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?
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
If you pass the department number as parameter to the report, then you can filter the data for the report base on that parameter.
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.
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

10 people are following this question.