Link to home
Start Free TrialLog in
Avatar of Endelm
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.
ASKER CERTIFIED SOLUTION
Avatar of rickchild
rickchild
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Endelm
Endelm

ASKER

Thanks a lot rickchild!

How can I use this in a query in Reporting Services?
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?
Avatar of Endelm

ASKER

I've found out how. Thanks a lot! :-)
OK Great, how did you do it?
Avatar of Endelm

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).