SSRS: Displaying User specific data on a report?

In SSRS you can access the User ID (=User! UserID). Set this up as an internal parameter for the report, and pass this into your dataset queries as a parameter.

Up vote 1 down vote favorite share g+ share fb share tw.

On SQL Server Reporting Services, I have the below requirnment for a report Users are authenticated for Reporting using Active Directory (windows domain accounts) We have an custom authentication DB and the data that should appear on the report are related to users on this Authentication DB Need to generate a report that list Sales data for all the stores, and "all data" should only be available to "Admin" users For "Non Admin" users, same report should only display sales data for the single store that they are associated with. (Not the whole list of sales data for all stores) Definition of "Admin", "Non Admin" user categories are defined on the custom Authentication DB. Really appreciate if someone could give me the directions on what approaches I should follow.

Please let me know if I should further clarify my requirements. Thanks. Reporting-services ssrs-2008 ssrs-reports reportingservices-2008 link|improve this question asked May 10 '11 at 15:51IG10521929 89% accept rate.

In SSRS you can access the User ID (=User! UserID). Set this up as an internal parameter for the report, and pass this into your dataset queries as a parameter.

Now you can join to your custom permissions table in your dataset queries. Use a query constructed with this method to populate your parameter drop down for "Store. " Also use the parameter again and double check that the user has permissions in your main query that returns results.

This will avoid a user being able to manually specify a store that they don't have permissions for. (Otherwise URL access would allow users access to reports they shouldn't get. ) Let me know if any of this isn't making sense.

Sorry Jamie for the delay in accepting this as I was away on holiday. Thanks a lot for the answer – IG105 May 25 '11 at 15:07.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.