Value is null or does not equal 2

[keeno]

Hello

I'm running Crystal Reports IX on a SQL Database and I am having a problem with what i thought was a simple formula.

I want to only display records which have an entry of "null" or is not equal to "Duplicate"

The formula I have is:
(isnull({HPD_Associations.Association_Type01}) or {HPD_Associations.Association_Type01} <> "Duplicate")

It is not working and I was woindering if anyone can assist with where I am going wrong

Thanks

David

 

[rchandr3]

Just keep that <> "Duplicate". If it is null, it wont be equal to "Duplicate", anyway.

Cheers,

Ravi

 

[Madawc]

Please clarify

not working

Are you getting more records than you expected? Less?

Since your test is in brackets, I assume you have other tests. Could they be at fault?

What you could do is to put each test into a formula field, as a 'boolian' that will say True or False. Display all of the records along with the boolians and see what you get.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You should check to see whether you have "convert nulls to default values" checked in file->report options, and then uncheck it if you do.

Then try a formula like:

(
isnull({HPD_Associations.Association_Type01}) or
trim({HPD_Associations.Association_Type01}) = "" or
{HPD_Associations.Association_Type01} <> "Duplicate"
)

-LB