Skip to Content
author's profile photo Former Member
Former Member

Blank value not recognized

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....

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 08:22 PM

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

    Thanks for you help

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 08:11 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 08:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 08:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 08:58 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.