Options

if statement

Horse06Horse06 Member Posts: 496
edited 2013-10-24 in NAV Three Tier
Hi expert, can anyone of you answer my question.

=iif((IsNothing(Fields!CompanyInfoPicture.Value)) = TRUE,TRUE,FALSE)
To my understanding, it means if there is no picture(logo) from the companyinfo table then (if it is true then). Am I right? Thank you very much!

Comments

  • Options
    BeliasBelias Member Posts: 2,998
    you can just set the expression to:
    =IsNothing(Fields!CompanyInfoPicture.Value
    
    it returns a boolean value. BTW, i think it should work as you said, but i'm not totally sure about what value has the picture field in the dataset (even if it's empty). I suggest you to try to test the picture with HASVALUE function in nav and return a boolean to the dataset. Just to be sure you're doing it right.
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.