Finding Null value different ways

[CrystalStart]

Hi!
I need to substitute Null fields with text so I wrote
IF (isNULL({Product.Color}))then "no color avail" else {Product.Color}
It works!

I also tried IIF (isnull({Product.color}), "no color avail", {Product.color})

it saved with no errors but produces no result. Why?

 

[Madawc]

The first way is the standard Crystal way. The other puzzles me: is it SQL? You can write SQL statements in their own section, but if you write such code for Crystal formulas, I'm not surprised it fails to work.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. My workplace is currently upgrading from Crystal 8.5 to Crystal 10,

Madawc Williams (East Anglia, UK)

 

[dgillz]

The second syntax is VB syntax. Are you setup to use VB Syntax?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com

 

[CrystalStart]

I am currently working with Access Reports and testing CrystalXI.
I used Crystal7 5 years ago.
So now I am trying to find a way to grt rid of syntax confusion.
I thought if it saved without error it should have worked.
Thanks
Any ideas on what to read or else?
THANKS