I have a working CF Report that displays images dynamically, but throws an error if the field in the database is null (Report data binding error Image not found).
I am trying to write an Iif statement, but cant seem to get it right.
This code works if the field has data
application.sImageLocation & "/" & query.listingimage1
My goal is to display the image represented in the field, but if the field is null or empty, I want to display an image in the same directory called "placeholder.gif"
This is the Iif statement I have been working with. Can you help me with what I am missing?
application.sImageLocation & "/" & Iif([query.listingimage1] IS "Null", "/fsboplaceholder.gif", query.listingimage1)