Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have few SSRS reports that I want to show to the user. But not all of them are to be showed to all users. Depending upon some attribute of the user, I need to hide/show few of the reports [or the webpart].

I want to avoid to carry all these filtering to inside the report.

I just saw SharePoint Web Part Visibility Filter Web Part on http://spvisibilityfilter.codeplex.com/. Is there any other simpler and out-of-the box capability in Sharepoint 2007 that I may use?

share|improve this question

1 Answer 1

You could put audience targetting on the web part properties. This would hide them from people not defined in the web part.

share|improve this answer
    
Thanks. But audience targettinng allows one to set it to certain group or users. What I was looking at is to set it to users having certain value in one of its attributes. Can I use audience targetting for this scenario? –  Kangkan Dec 7 '12 at 4:06
    
You could probably use the User Filter web part since you're on enterprise. Configure it and your SSRS view(s) so that they're pushing the correct user attribute from the filter web part to the connected SSRS web part. That should then trim the reports out that aren't applicable. –  PirateEric Dec 7 '12 at 6:54
    
Is there a User Filter available on Sharepoint 2007/MSPS 2005? I could not see it. –  Kangkan Dec 7 '12 at 7:18
    
Make sure the Enterprise features are enabled in Site Settings and when you go to add a web part to your page, it should appear in the Filters section. It might be called Current User Filter. –  PirateEric Dec 9 '12 at 5:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.