Endelm
asked on
Reporting Services - Access control
Hi,
I'm trying to make a report that:
If person x uses the report, it can only access reports that conserns him or her.
How is this possable?
Thank you.
P.S. My idea was to somehow get the windows user of the person using the report, and then use the windows user in your queries to check if the person has access or not.
I'm trying to make a report that:
If person x uses the report, it can only access reports that conserns him or her.
How is this possable?
Thank you.
P.S. My idea was to somehow get the windows user of the person using the report, and then use the windows user in your queries to check if the person has access or not.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you looking to create one report with links to other reports they are allowed to see, or only show content in a report which the users can see?
ASKER
I've found out how. Thanks a lot! :-)
OK Great, how did you do it?
ASKER
I used a parameter in a query and gave it the default value = =User!UserID
Then I set the parameter to be hidden (checkbox in the parameter settings).
Then I set the parameter to be hidden (checkbox in the parameter settings).
ASKER
How can I use this in a query in Reporting Services?