Null Value Capture to Print on Reports

[mjm19]

Using CR 7.5 trying to capture results in a hospital setting where the value of a test is pending. The result field from the database is blank:

Pt Number Test Result

12345 TSH 1.50
12346 TSH
12347 TSH 5.00

I've tried using different formulas saying the result = Null, "", " ", but can't get patient 12346 to only show up on the report. Any ideas ??

Thanks

 

[Reebo99]

Try:

IsNull(result) or
result = '' or
Len(result) = 0

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[GJParker]

Try this in your record selection formula

IsNull({MyTable.MyField})

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[GJParker]

The Scottish server must be faster than mine Reebo.



Gary Parker
MIS Data Analyst
Manchester, England

 

[Reebo99]

I'm not in Scotland anymore. I'm contracting in Kettering (east midlands) now.

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.