Hide tablix if the parameters are null value

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  August 15, 2018 at 1:39 pm

  #361046

  Hi ,
   I have a report which has two parameters 1)ENTER ID  ( you can enter id )  2) SELECT ID LIST  (multiple values) .......Both of the parameters set to value ' ' /null. so when i preview report , by default parameters are set to  null , it still shows empty tablix. How can i hide tablix if parameters both are not selected?

• pietlinden

  SSC Guru

  Points: 63594

  More actions

  August 15, 2018 at 2:05 pm

  #2001986

  Can't you check the Parameters.Count property to see how many items are selected and use that to determine whether an object is visible?  Something like

  Ctl.Visible = (Parameters.Count>=2)

• sgmunson

  SSC Guru

  Points: 110651

  More actions

  August 16, 2018 at 7:05 am

  #2002052

  komal145 - Wednesday, August 15, 2018 1:39 PM

  Hi ,
   I have a report which has two parameters 1)ENTER ID  ( you can enter id )  2) SELECT ID LIST  (multiple values) .......Both of the parameters set to value ' ' /null. so when i preview report , by default parameters are set to  null , it still shows empty tablix. How can i hide tablix if parameters both are not selected?

  Set the visibility of the tablix to an expression:
  =IIF(IsNothing(Parameters!ParmName1.Value), IIF(IsNothing(Parameters!ParmName2.Value),True, False),False)

  Be sure to substitute in the names of your parameters.

  Steve (aka sgmunson)
  Rent Servers for Income (picks and shovels strategy)