April 6, 2011 at 8:22 am
My team is currently using SQL Server 2008 R2. We are going to display our reports in SharePoint 2007. We need to have the capability to display reports to certain users and restrict other users from viewing them. In addition, when we create a report that a user can view, they should only see data related to them. For example, we create a report about contractor information. If a user comes in, he is a contractor x, he should be only able to see the data in the report related to contractor x and not information about contractor y or contractor z. Does anybody know how to do this?
April 6, 2011 at 9:29 am
With regard to a user seeing data on a report that is pertinent to them only, make the user information a parameter input on the report and then feed that information with the user logon.
With regard to not allowing some users to view some reports, you should do that with standard security models in AD and roles and permissions in the Report Manager
April 7, 2011 at 6:26 am
I thought you couldn't use Report Manager when Reporting Services is integrated with SharePoint.
April 7, 2011 at 7:43 am
Oops, missed that. Conceptually I think it is the same, a parameter for the user in the report definition. You need to be able to grab the user info and have Sharepoint pass that with any other parameters to the report.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply