question

NaveenPrabhakar-5516 avatar image
0 Votes"
NaveenPrabhakar-5516 asked Joyzhao-MSFT edited

Need to show certain parameter values to respective user in SSRS 2008

Hi,

I have created a report in SSRS where there is a filter for locations.

There are 5 locations defined in the SQL database.

Based on the user running the report, I need to show the report for that location.

Example, User1 is running the report. User1 should be able to see report for Location1 only.
But User2 can see the report for all Locations.

Kindly advise if there is a way to do it.

Regards,
Naveen

sql-server-reporting-services
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 @NaveenPrabhakar-5516
If you need users to have different permissions to view different parameter values, you could choose to create Data-Driven Subscriptions.
A data-driven subscription is a query-based subscription that gets the data values used for processing the subscription at run time. When the subscription is triggered, a query is processed to get up-to-date information about recipients, report delivery options, rendering formats, and parameter settings.
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.