July 22, 2008 at 6:45 am
I've developed an SSRS "scorecard" report for Sales Rep performance, which can be viewed by the entire Sales Rep team. It's deployed via ReportViewer over MOSS 2007 Integrated Mode. Exec VP want the ability for a Rep to drill-down to a detailed layer (which is easy and completed), but only wants the the Rep to see his/her own details (secured by their AD account).
I have not found any features within SSRS to allow this type of security. Has anyone done something similar? The reports are stored in a Doc Library on Sharepoint, and the Reps have read-only access to the .rdl file. I don't see a way to secure the drill down in Sharepoint either, since it's built into the same .rdl file.
Any thoughts on this topic?
Thanks.
July 23, 2008 at 4:53 am
Not sure quite how secure this is, but if your drill down is a sub-report then you can control the visibility of the sub-report using an expression, so you could do something like:
=IIF(User!UserID="OKUserName",TRUE,FALSE)
Let me know if you think this will work for you.
Good luck,
Nigel West
UK
July 23, 2008 at 7:04 am
Thanks, Nigel. I should clarify that I am using the Jump to Report feature and not drill-down (my fault for mis-stating that). In your example, I see what you're trying to do, but I'm not sure how I capture the user's AD account info.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply