Null Field Excluded 1

[jpstrzoch]

I am using Crystal XI with an SQL 2005 DB. I need to exclude within my selection criteria a string field called CUSTOM_DATA7 when it contains a "K".

Simple enough......{CUSTOM_DATA7} <> "K".

But I notice that when records have a "null" value, they do not appear on the report. I need to include the "null" records but exclude the fields populated with a "k".

Additionally, this field could have other values such as "w".

How can I account for this in my Selection Expert selection statement?

Any help would be much appreciated.

 

[dgillz]

You should try turning "convert null field values to default" on under file, options.

If that doesn't work, Gt to report, selection formulas, record, and manually type in the formula:

Isnull({custom_data}) or {custom_data}<>"K"

Note that this is NOT using the select expert, which is way too limiting. I have not used it in a single time in 11+ years.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?