Crystal Reports: Pulling Null Values

[mwolfe571]

I am trying to run a report where it will pull all date fields that are blank. I have tried the field = null and it has not worked.

[jggtz]

Welcome to CodeGuru forums!

In CR ide, select menu / File / Report Options
It will display a properties page
Uncheck : "Convert Database NULL Values to Default"
Add a Record Selection Formula

IsNull ({TableName.DateFieldName})

It will display all the records that has a null value in that field
(change the table & field names to the real ones)


OR

In CR ide, select menu / File / Report Options
It will display a properties page
Check : "Convert Database NULL Values to Default"
Add a Record Selection Formula

DateValue ({TableName.DateFieldName}) = DateValue(0,0,0)

It will display all the records that had a null value in that field before CR converted them internally to a zero date
(change the table & field names to the real ones)