Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Thursday, February 09, 2012 12:48 PM
Points: 2, Visits: 27
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, October 10, 2013 10:15 AM
Points: 459, Visits: 182
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