Crystal Reports Null Fields

      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
Who is Participating?
mlmccConnect With a Mentor Commented:
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

   {YourDatefield} <= {?DateParameter}

daskas27Author Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.