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