How to hide/view a SSRS report parameter control dynamically at runtime?

[balushanmugham]

Hi,

I am using SSRS 2005. I want to enable/disable or hide/view parameters based on another parameter selection.

Say Suppose I have 5 parameters. User selects first value in first parameter I should show only Second parameter and hide remaining 3 parameters (Parameter 3,Parameter 4 & Parameter 5).
If user selects second value in first parameter I should show third parameter and hide remaining 3 parameters(Parameter 2,Parameter 4 & Parameter 5).
Similarly If user selects third value in first parameter I should show fourth and fifth parameter and hide remaining 2 parameters(Parameter 2 & Parameter 3).
There is no relationship between these parameters except user selection.

I can not see any Visible property for report parameters.
Any "builtin" support in SSRS for this scenario.


Appreciate your help.
Regards,
Bala

 

[SQLScholar]

As far as i am aware you cannot hide parameters. The only thing i can sugguest is setting them to "unused" or similar dependant on the other filters. Then obviously you will have to cope with this "unused" wherever this parameter is used.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

As far as i am aware you cannot hide parameters. The only thing i can sugguest is setting them to "unused" or similar dependant on the other filters. Then obviously you will have to cope with this "unused" wherever this parameter is used.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------