Skip to Content
avatar image
Former Member

Null column Value, Not displaying record in report

Dear Experts,

I am using a single table in the report and applied date & company filter, where I am getting 115 records.

When I run through the same filter in the backend I am getting 118 records.

I find out the 3 missing records and difference in the report, When Description value has null value then that record is not displaying in crystal report.

Could you please suggest how reports filtered out the null record.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 10, 2017 at 04:34 PM

    Hi Sriram,

    You have your filter check for nulls, like:


    Or you can go to File | Report Options and turn on the option for Convert NULL Values to Default. This will change the null in a String field to an empty string or a null in a numeric field to a 0.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Brian,

      Original Filter i want to apply in report .

      1. {incident.opened_at} in LastFullMonth and {incident.dv_company} = "Discover"

      For Testing Purpose i just checked with below filter, where its not isplaying any record.

      2. isnull({incident.short_description}) .

      Please check attached image file, In Application its displaying all null value records, Please check 6th row in App.Jpeg,

      where in report it's not displaying Report.Jpeg.

      app.jpg report.jpg

      app.jpg (92.8 kB)
      report.jpg (420.5 kB)
  • Jul 11, 2017 at 04:20 PM

    Hi Sriram,

    I want to make sure I cover all the bases so I apologize if you've already done some things I'm asking.

    Can you check the open_at date for T0036251? Looking at the other rows, I would expect it to be June 1 but strange things tend to happen with data sometimes.

    In the report, if you go to Database | Show SQL Query, you should be able to copy the query and paste it into your database. Does that row appear?

    Instead of IsNull, try checking for an empty string like:

    {incident.short_description} = ""; 

    No space between the quotes.

    Good luck,


    Add comment
    10|10000 characters needed characters exceeded