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

Select Expert using ISNULL

I am using Crystal Reports XI and I have a table that has customer names with "NULL" values. I am wanting to print all of those records in the table with the NULL value. Can someone help me with this issue.

Thanks Jim

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 03:20 PM

    HI Jim,

    1) Goto > Report Options >Check the option "Convert Database Null Values to default".

    And also check the option " Convert the other values to default".

    2) Now goto > Record Selection Formula > Select "Default Values for null". and write the below formula

    isnull(Database_Field)= true.

    Hope this helps!

    Regards,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 03:16 PM

    go to file, report options

    check null value boxes

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 03:32 PM

    I performed those steps, and added in the Reports Selection "isnull{CRD1.U_ShipName}= true" ,but I am receiving the following error, "The remaining text does not appear to be part of the formula". Im not sure what this error is.

    Thanks Jim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 03:41 PM

    Hi,

    Please try the following:

    isnull({CRD1.U_ShipName})= true;

    Regards,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 03:46 PM

    Thanks for the response, but it didnt select any records. I am trying to list all of the records where this field has a null value in the {CRD1.U_ShipName} field.

    Thanks Jim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 03:51 PM

    Thanks for the response, That worked.

    Thanks Jim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2008 at 12:49 AM

    Just to throw my $.02 in, I never turn on the report option to change null values to default. it vastly complecates any other forumla you might want to write in the report, and can cause performance issues under certian circumstances.

    I use 'default values for null' in the formula workshop for the select expert, or explicitly in formulas where I need that functionality.

    Also, just a picky point, but asing "isnull() = true" is redundant. if the field is null, isnull evaluates to true, and then you're asking if true = true. If it isn't null you're asking if false=true which is clearly false. In cases such as these isnull() alone will suffice.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I ran across this while searching a solution for a simular problem i was having. When i used a select Formula

      isnull({table.feild}) it was clearing my entire report of informaiton. I had used this on previous versions of Oracle and Crystal. I just recently was moved to Crystal 11 and I believe Oracle 11. The solution it turned out was the "=true" thus "isnull({table.feild}) = true"...... i don't know what is different but this was the only way I could get the desired effect of selecting the null records. Go figure

      Edited by: Kschuett on Feb 10, 2012 12:18 AM

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.