Simple Simple Question

[keeno]

Hello

Using Crystal Reports 9 and I have a field which I need to select 'One Of' from. One of the 'One Of' I need to select is if the field is Blank.

I have tried this via the Select Expert but it doesn't seem to acknowledge null, blank spaces anything.

Therefore I am asking whether I need to create a fomula which will select required data from a list including if the field in question is blank

Any help would be greatly appreciated

Thanks

Keeno

 

[synapsevampire]

You should post what you tried, the database, the data type, in general, technical information.

The record selection for testing a "blank" field should be something like:

isnull({table.field})
or
trim({table.field}) = ""

This assumes a string type.

-k