Hiding Report Parameters -- sql server reporting services

rwhitelaw
5/25/2006 3:33:02 PM

I have a report with 3 parameters (Run Date, Branch, and Account Manager #).
We are using this report to show 3 different views (Corporate, Branch, and
Account Manager) and want to hide/disable the parameters that are not
required.

If the user wants to view the Corporate View, only the Run Date parameter is
to be displayed. The Branch and Account Manager # are defaulted to All using
the URL.

If the user wants to view the Branch View, only the Run Date and Branch
parameters are to be displayed. The Account Manager # is defaulted to All
using the URL.

Is it possible to hide these parameters in SQL Reporting Services 2000 using
the URL passed to the report?

Tim Dot NoSpam
5/26/2006 10:59:19 AM

Yes. Push the report to a directory then create linked reports in 3
separate folders (corp, branch, acctMgr). You can specify whether or not
the parameter is hidden when you set up the linked report. You can then
grant the appropriate privileges on each of the three folders (don't grant
privileges to the three roles below on the primary report).

HTH

-Tim

[quoted text, click to view]

sql server reporting services : Hiding Report Parameters