How to use "null" field?

[bloomlight]

We are using Crystal Report v10. I have a question about using a "Date" filed which is null.

I know some SQL coding, but new in Crystal Report. When I type {Admission Date} is null, I got error message saying that "there is an error in this formula, do you want to save it anyway?". I tried both "Yes" and "No" to the question, neither of them will generate the correct report. How to use null filed in crystal report?

Is a way that I can type or edit SQL coding inside of Crystal Report? Thanks.

 

[Madawc]

You'd say

IsNull({your.date})...

You must test for nulls first. A Crystal formula will stop when it finds a null, even if there is logic for it later on.

For your other question, do a SEARCH for SQL Command etc.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[chelseatech]

Also make sure you haven't set the report option "Convert NULL database values to Default". That will change a null date field to Date(0,0,0).

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm