hide a parameter based on the value of another parameter

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  July 19, 2013 at 2:48 am

  #280548

  Hi geniuses!

  Is there a way in SSRS to hide a report parameter based on the value of another report parameter?

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 19, 2013 at 2:58 am

  #1633891

  Apparently not:

  http://www.bidn.com/forums/microsoft-business-intelligence/reporting-services/190/can-we-hide-the-parameter-based-on-the-value-of-another-parameter

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Snigdha Vartak

  Default port

  Points: 1486

  More actions

  August 8, 2013 at 12:43 pm

  #1639946

  Hi,

  By design, the parameters will be rendered while the report is processing. This means there is no option to hide a parameter at run-time :crying:.

  I would suggest you implementing a custom parameter interface using ASP.NET, and then using Report Viewer control to display the report.

  Please refer:

  http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c233cf39-bff3-4519-8459-58b24e82ec29/conditionally-hiding-parameters-in-ssrs-2005

  Thanks