How to hide parameter based on another parameter value in SSRS

reporting-services ssrs-2008 ssrs-2008-r2 ssrs-tablix ssrs-grouping
SqlLearner picture SqlLearner · Oct 8, 2014 · Viewed 36.2k times · Source

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can this be achieved in SSRS?

Answer

sajad picture sajad · Jul 9, 2015

As per Nathan's comment i am adding Amar's comment here as answer/partial answer

Unfortunately, you cannot change a parameter's visibility during run time. Alternatively, you can control the second parameter's values based on the selected value of the first parameter.

Check this post - Hide parameter (dropdown control from the toolbar) in SSRS based on another Parameter

Related questions

how to display multivalued parameter value in SSRS text box

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should …

Read More
How to align different Tablix in SSRS

I have a SSRS report in which i need to align multiple tablix in same Order as i need to export to EXCEL The other tablix's is just a copy of the first tablix with only change of data set.…

Read More
Interactive sorting In SSRS on Values - Matrix report

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value. We are grouping rows by Primary Key and grouping column by Columns and use Value as data. My Matrix Report - …

Read More