-
October 10th, 2012, 09:53 AM
#1
Crystal Reports: Pulling Null Values
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.
-
October 10th, 2012, 10:31 PM
#2
Re: Crystal Reports: Pulling Null Values
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
Code:
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
Code:
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)
Last edited by jggtz; October 11th, 2012 at 10:06 AM.
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|