CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Oct 2012
    Posts
    1

    Crystal Reports: Pulling Null Values

    I am trying to run a report where it will pull all date fields that are blank. I have tried the field = null and it has not worked.

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    Re: Crystal Reports: Pulling Null Values

    Welcome to CodeGuru forums!

    In CR ide, select menu / File / Report Options
    It will display a properties page
    Uncheck : "Convert Database NULL Values to Default"
    Add a Record Selection Formula
    Code:
    IsNull ({TableName.DateFieldName})
    It will display all the records that has a null value in that field
    (change the table & field names to the real ones)


    OR

    In CR ide, select menu / File / Report Options
    It will display a properties page
    Check : "Convert Database NULL Values to Default"
    Add a Record Selection Formula
    Code:
    DateValue ({TableName.DateFieldName}) = DateValue(0,0,0)
    It will display all the records that had a null value in that field before CR converted them internally to a zero date
    (change the table & field names to the real ones)
    Last edited by jggtz; October 11th, 2012 at 10:06 AM.
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured