PDA

Click to See Complete Forum and Search --> : Null Values in Crystal


JackV
Jun 15th, 2000, 10:33 PM
I need to display a default text value in Crystal Reports whenever a certain field is null in the recordset and I can't seem to figure out how. Thanks in advance.

-Jack Vinitsky

Negative0
Jun 16th, 2000, 01:33 AM
If you use a formula field you can check a field value:

if length({table.field})>0 then table.field else "Default Value"

Hope this helps