Post reply

Hide tablix if the parameters are null value

  • 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?

  • 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)

  • 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)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply