Monday, March 26, 2012

Hide / Disable Report Parameter

Hi

I am using reporting services 2005. (sql server 2005 Sp2).

I have two parameters on the reports. Both parameter are not related to each other.

If user selects first parameter value I want to Hide or Disable second parameter drop down.

Is it possible in Reporting services?

Thanks for everyone's help.

Regards

Swam

I am guessing a big NO

You could simply not use the 2nd parameter in the report

and have a text with "2nd parameter will not be used if 1st parameter is used"

|||

Swam wrote:

If user selects first parameter value I want to Hide or Disable second parameter drop down.

You can't do that, but what you can do is make the default value and even the *contents* of the second parameter dependant on what is selected in the first parameter. I would have the second dropdown default to null or an empty string if a value was selected in the first dropdown.

|||Thanks for your help..|||Thanks for your help....

No comments:

Post a Comment