condition to hide table in ssrs?

mdsrmdsr Member Posts: 163
if field has value then only show table otherwise hide table is following code right?
=IIf(Fields!DeliverdtoAdd_SalesHeader.Value='',False,True)

Answers

  • AlexDenAlexDen Member Posts: 86
    vice versa, in ssrs you make condition for hidden property.

    tablix is hidden if:
    =IIf((Fields!DeliverdtoAdd_SalesHeader.Value='') OR IsNothing(Fields!DeliverdtoAdd_SalesHeader.Value),True,False)
    
  • RockWithNAVRockWithNAV Member Posts: 1,139
    Yes is has always been a confusion on RDLS side, in RDLC side if you say FALSE means you want to execute because the IIF condition is failing and the opposite is TRUE.
  • Wisa123Wisa123 Member Posts: 308
    edited 2019-09-12
    As AlexDen mentioned I think the problem is in evaluating whether the String is actually String.Empty.

    I've seen some workarounds converting to String and then evaluating the Length of that
    =Iif(Len(CStr(Fieds!...)) = 0, True, False)
    

    maybe that's worth a shot if the problem still persists.
    Austrian NAV/BC Dev
Sign In or Register to comment.