Blank value not recognized

[Former Member]

Hello all,

I have a flag that has values: Yes, No, Blank....In my report, I'm only interested in showing the values with blank, however when I go to the selection criteria and try to select: Equal to, I don't get the blank value, all there is is Yes and No...

Is there a way to tell Crystal how to filter for Blanks only?

Thanks so much for your help....

[Former Member · Accepted solution]

I hope it's worthy to mention that this database is a DB2....

Thanks for you help

[Former Member · Accepted solution]

It is though I have not used Crystal and db2. Try it, and if it fails try a blank:

{field}=" "

. There may actually be something there.

[Former Member]

Thank you ...that solved it....thanks so much

[Former Member]

if IsNull does not work, try

{field}=""

in a my SQL database, text/date fields seem to prefer this test in order to find the empty fields

[Former Member]

Thanks for the reply....

These records that I'm trying to display are not Null, they're Blanks reason I'm saying this is because when I used the formula you specified above isNull({ZZDEPPROOF.DEP_PROOF}), the value returned was FALSE.

I still can't display blank values only...

Thanks

[Former Member]

Well, that depends, are they blanks, or nulls

You can create a formula to test for nulls or blanks either one.

IsNull({orders.ORDER AMOUNT})

will produce true / false

Not IsNull({orders.ORDER AMOUNT})

When used as a record selection formula, includes in the report only those records that have something other than a null value in the {orders.ORDER AMOUNT} field.

Comments

Some databases support null data values and others do not. This function will not work if the active database(s) do not support null values. If the database(s) do support null values, the function can be used to reference the null values that get created as the result of a failed lookup while joining.

Note: Zero and blank (empty or " ") are not null values.