Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disablling/hiding parameters through url

Status
Not open for further replies.

sds814

Programmer
Feb 18, 2008
164
US
For one group of users they should be able to see a report parameter call Company Name. Another set of users should not be able to see Company Name. Both set of users are accessing the reports through different web pages. Is there a way that I can disable/hide the report through the url of the report?

For example,
I'm using SSRS 2005
 
I don't think you can as there is no expression editor for the visibility of parameters in BIDS. One option is to leave it visible, but for the certain set of users, only allow one option in the drop-down. For example, if some users can see multiple company names, and others can only see a single company, make the parameter load just the single company for those users. If company doesn't apply whatsoever, make the parameter say "N/A" or something to that affect. You can control what is loaded into the parameter's values simply by using SQL in the dataset bound to the parameter.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top