Member_2_207537
asked on
NULL usage in crystal reports formula/query
Hi
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?
tcss
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?
tcss
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.