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