CR 9 IF ELSE does not do the else 1

[taterday]

Using crystal syntax
I can not get the else to work. This is a label. I have a formula with this code:

if trim({fieldname}) <> "" then
use these two fields to create the label
else
use two other fields to create the label

When the logical IF fieldname is true the IF has the data requested.
if fieldname is false the else comes out as blank. The field does not have anything in the label.

Please help.

 

[IanWaterman]

Its probably because that Field is actually null try

Also you must deal with nulls first

if isnull(fieldname) or trim({fieldname}) = "" then
use two other fields to create the label
else
use these two other fields to create the label

Ian

 

[taterday]

You were right!

Thank you,

You earned your star.