Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Hide parameter selections for SSRS based on reporting level seletions Expand / Collapse
Posted Thursday, November 12, 2009 6:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 1, 2015 9:55 AM
Points: 2, Visits: 30
I am constructing a SSRS report that reports data at 4 levels:

National level
Network Level
Facility Level
Division Level

I have a table that reports workload at 4 levels. I have user parameters set up for the user to select the level of detail for their report, i.e. national aggregate numbers, a Network (possible of 23 networks) level, Facility level. Currently, if a user selects the national level, they are still prompted to select a Network and a Facility, which I want to change. If the user chooses the national level, I want the selections for Network level and facility level to not be available for selection,i.e. either greyed out or not visible. If they select a Network level, I want the selection for Facility level to be greyed out or not available/visible, etc. Can anyone tell me how to accomplish this? Thanks
Post #817791
Posted Wednesday, July 28, 2010 3:28 AM


Group: General Forum Members
Last Login: Wednesday, October 5, 2016 8:05 AM
Points: 459, Visits: 226
i don't think you can write expression to hide or gray out the parameter.
Post #959905
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse