Question on Strings

[ChipsAhoy]

I have a Crystal Report field that is reported as a 60 character string. Some records do not have any data in this field. I have attempted to test for null values and additionally have set the following test formula:

IF {data field}=" " THEN "No Input" Else {data field}

I have 443 records, until I attempt to add the "data field" to the report, then I have 337 records. The difference is the records without any entries in the "data field". I would like to show these records with a label stating "No Input".

I am using Version 8.0

 

[Naith]

The mistake you've made is in trying to represent nulls as " ", which is a not null value.

Try this instead:

If IsNull({data field}) or
Trim({data field}) = ""
Then "No Input"
Else {data field};

Naith