Hide parameter selections for SSRS based on reporting level seletions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Hide parameter selections for SSRS based on...

Hide parameter selections for SSRS based on reporting level seletions

Rate Topic

Display Mode

Topic Options

Author

Message

jan.freeman

Posted Thursday, November 12, 2009 6:47 AM

Forum 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

mverma4you

Posted Wednesday, July 28, 2010 3:28 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, November 09, 2012 8:46 AM
Points: 459, Visits: 180

i don't think you can write expression to hide or gray out the parameter.

Post #959905

« Prev Topic | Next Topic »

Permissions