Tablix conditional visibility

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  January 11, 2016 at 8:31 am

  #310675

  I have a report with few tablix joining together with their visibility set on following condition:

  For 1st tablix, nothing as it will show whatsoever

  For 2nd tablix,

  =IIF(First(Fields!Param2.Value, "DataSet_Show_Or_Hide")=0,True,False)

  For 3rd tablix,

  =IIF(First(Fields!Param3.Value, "DataSet_Show_Or_Hide")=0,True,False)

  and so on.

  I think it should hide the tablix if the param is having 0 value. And it's working correctly but it shows that place of tablix as blank. What i want is the one on the right side should replace it,