ISNULL test not working

[kmarino]

I have the following nested IF statement that displays nothing instead of "(no applicable code)". The P,E,I, and W is working. Does anyone know why? I can't seem to make the ISNULL function to work in other report either.

IF {V_DEPENDENT.DEPCOBRAELIGIBLITY} = "P" then "Participating"
else
IF {V_DEPENDENT.DEPCOBRAELIGIBLITY} = "E" then "Eligibile"
else
IF {V_DEPENDENT.DEPCOBRAELIGIBLITY} = "I" then "Ineligibile"
else
IF {V_DEPENDENT.DEPCOBRAELIGIBLITY} = "W" then "Waived"
else
IF ISNULL({V_DEPENDENT.DEPCOBRAELIGIBLITY}) then "(no applicable code)"
else
{V_DEPENDENT.DEPCOBRAELIGIBLITY}

 

[mbarron]

Try putting the isnull test first. Not quite sure why, but have seen the IsNull first suggestion before

Also try using the following:
IF {V_DEPENDENT.DEPCOBRAELIGIBLITY}="" then "(no applicable code)"
Mike

Before: After

 

[kmarino]

Thanks Mike. I should have known enough to try those suggestions first. I just seem determined to use the ISNULL feature.

I did have to use the = "" option. Moving the ISNULL first didn't do anything.

Kathleen

 

[dgillz]

Try length(trim({YourField}))=0 as your test. I have had to do this on occassion, especially for old btrieve databases. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[aklein]

>I did have to use the = "" option. Moving the ISNULL first didn't do anything.

That says that your field is blank, not null. The two aren't the same.