if statement

Horse06

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!

Belias

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.