Excluded Field Criteria also Excludes Nulls 1

[OldGrayMare]

CRYSTAL 11

We have Products broken down by Model/Version. Some of our NCID Product Model/Versions are blank. I am attempting to print all records that have the Product Name of "NCID" where the Product Model/Version does not include "NG". In other words, I want all NCID Product Names where the Product Model/Version is either blank or = "7.x."

My formula below results in only the "7.x" Product Model/Version records but doesn't include the nulls.

{HPD_Help_Desk.Company} = "ITS Service Desk" and
{HPD_Help_Desk.Reported Date} > DateAdd ("d", -49,{@SpecificDate} ) and
{HPD_Help_Desk.Reported Date} < {@SpecificDate} and
{HPD_Help_Desk.Product Model/Version} <> "NG" and
{HPD_Help_Desk.Product Name} = "NCID"

If anyone could please tell me what is wrong with my logic above, I'd appreciate it.

 

[Turkbear]

Hi,
In case your database treats blanks as NULLs then this should do it:

(
IsNull({HPD_Help_Desk.Product Model/Version}) 
OR
Trim({HPD_Help_Desk.Product Model/Version}) = ""
OR
{HPD_Help_Desk.Product Model/Version} <> "NG"
 )
AND
{HPD_Help_Desk.Company} = "ITS Service Desk"
 and
{HPD_Help_Desk.Reported Date} > DateAdd ("d", -49,{@SpecificDate} )
 and
{HPD_Help_Desk.Reported Date} < {@SpecificDate} and
and
{HPD_Help_Desk.Product Name} = "NCID"

NULL is an odd value and cannot be tested except as to its existance or non-existance;it is not EQUAL to anything, including itself, and is not NOT EQUAL to anything.

In CR you need to test for a NULL first.







To Paraphrase:"The Help you get is proportional to the Help you give.."