MOSS Forum

 
Home » Forum » MOSS       Ask a questionRSS Feeds

Sharepoint Reporting Services - Role base security possible in Reports?

  Asked By: Mohammad Meadows         Date: Mar 28, 2009      Category: MOSS      Views: 565
 

In my MOSS site I have deployed a report. I need to give access to the contents of these reports as per the person logged in into the site. For eg:

If in my report I have

ManagerID...............................ManagerName.......................Details
X..............................................ABC........................................X1xxxxxxxxx
..............................................................................................X2xxxxxxxxx
..............................................................................................X3xxxxxxxxx
Y..............................................JKL.........................................Y1yyyyyyyyy
..............................................................................................Y2yyyyyyyyy
..............................................................................................Y3yyyyyyyyy
Z..............................................STU.........................................Z1zzzzzzzzz
...............................................................................................Z2zzzzzzzzz
...............................................................................................Z3zzzzzzzzz


If Manager ABC is logged in to the MOSS site he should see only details X1,X2 and X3. and not the Y1,Y2,Y3,Z1,Z2 and Z3. Likewise if Manager JKL should see only details Y1,Y2 and Y3. Manager STU should see only Z!,Z2 and Z3.

Is there any way to do this? Can anyone help me?

Tagged:                  

 

1 Answer Found

 
Answer #1       Answered By: Tamika Cummings          Answered On: Mar 28, 2009       

I found the solution for the issue.

I could solve it at SSRS itself.

Took the user id of the person  who is viewing the report  from Users!UserID global parameter of the report and gave it to my query as the parameter. I retrieved the data for that particular Manager ID only from the DB and displayed it in my reports.

 


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].