NULL usage in crystal reports formula/query

Posted on 2008-11-06
Last Modified: 2012-05-05

I am using the version of Crystal reports that comes with VS 2005.

I have simple report that I whish to extract information out of the database with.
All works well except where the value of one of the criteria fields is NULL.

My Record selection formula looks something like this
{UpdIND} <> "D" and
{Code} = {?p_Code} and
(({Feld1} < {?Tmp} ) OR {isnull("Field1})))

Basically I want the data where field1 is less than the required value or field1 is null.

When I try to use the "Field1 IS NULL" syntax, crystal rejects it as if the "IS NULL" portion should not be there.
What is the correct way to do this?

Question by:tcss
    1 Comment
    LVL 1

    Accepted Solution


    Reference from

    Th null part of the expression must come first.
    Strange but it worked.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now