condition to hide table in ssrs?

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

Answers

  • AlexDen
    AlexDen 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)
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    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.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • Wisa123
    Wisa123 Member Posts: 309
    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

Categories