Solved

Crystal Reports Null Fields

Posted on 2013-11-23
2
452 Views
Last Modified: 2013-12-05
Hello,
      I have a Crystal report that uses a date field to pull data. I have this report field selecting by “less than or equal to” a date I have decided was a workable date. However, some of these date fields are null. How do I tell the report to keep using the “less than or equal to” date as well as if it is null? What I mean is that I would like to show both the “less than or equal to” and null items.

Thank you
0
Comment
Question by:daskas27
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39671451
Remember NULL is the ABSENSE of a value.  It is not a value and cannot be compared.
When Crystal encounters a NULL it terminates the evaluation and the result is indeterminate.

Instead you have to test for it.

Try this

(
   IsNull({YourDatefield})
   OR
   {YourDatefield} <= {?DateParameter}
)

mlmcc
0
 

Author Closing Comment

by:daskas27
ID: 39697908
Thank you
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question