Reputation: 81
I have design level problem. I am struggling to find the right solution. I am new to SSRS. I have a requirement to create SSRS reports for internal teams in the company(Basically for Marketing, Sales, Billing etc) where one department team cannot access other department reports only admin can able to access all the reports. this reports URL we need to invoke in our company website. Firstly IS there a way to differentiate the departments with out a new credentials given to them ? Anything like asking them to provide Network credentials? any information would be Appreciated.
Upvotes: 1
Views: 307
Reputation: 18950
We are talking about viewing reports in the web view/report builder, right.
One option is to create a folder for specific users and link or create the report in that folder. Or deny general access to the folder and then subscribe specific users.
Or implement user based authentication on the report itself.
References:
Upvotes: 2