Change the parameters based on Main Parameter

• sql server developer

  SSCarpal Tunnel

  Points: 4746

  More actions

  August 16, 2012 at 10:51 am

  #266022

  Hi All,

  I've report that has 4 parameters, say ParA, ParB, ParC and ParD.

  ParA is the main parameter upon which other parameters are dependent

  If ParA = 'X' then the user should be able to select options from ParB and ParC (ParD should be hidden)

  If ParB = 'Y' then the user should be able to select options from ParD (ParB and ParC should be hidden)

  I really appreciate if someone could assist me with this.

  Thanks in advance!

• Snigdha Vartak

  Default port

  Points: 1486

  More actions

  August 8, 2013 at 11:53 am

  #1639927

  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

• Amit Raut

  SSCrazy

  Points: 2613

  More actions

  September 30, 2013 at 8:30 pm

  #1654763

  Agree with Snigdha. It's not supported in SSRS.