In SQL Reporting services, is there a way to dynamically hide some parameters (but not all) from users?

Question

Is there a way to have a SQL Reporting Services (2005) dynamically show or hide parameters?

For example, if the user is a "power user," show parameters A, B, C, D, but if you're a novice, show only A & B?

This isn't a security or "limiting" concern, just an attempt to not overwhelm some users or overly restrict others.

Thanks!

Answer 1

Not as simply as you'd like, I'm sorry.

One way would be to create a linked report for different users, say "Report (Advanced filter)" and "Report (Simple filter)". You can hide parameters in the properties of the linked report.

Another way, assuming you use User!UserID, would be to change the contents of list paremeters based on this (by filtering on the database side when you bind the parameter to a data set).

Finally, you may be able to do it with a ReportViewer control but this requires an ASP.NET wrapper.