Selection Formula Problem 1

[Crystalyzer]

I have a simple selection formula as follows:

{Prospects.Owner}<>"Joe"

The problem is that when I use this selection formula any records that have a NULL value in owner are filtered out as well. Am I doing something wrong?

Thanks and best regards,
-Lloyd

 

[lbass]

Try using:

isnull({Prospects.Owner}) or
{Prospects.Owner} <> "Joe"

-LB

 

[Crystalyzer]

LB

I tried that, however there are other owners that get filtered out then. Effectively I want my report to contain all owners including records with no owner and exclude Joe.



Thanks and best regards,
-Lloyd

 

[lbass]

The formula should do exactly what you want. Maybe you should try it again. Can't see any reason why other owners would get excluded.

-LB

 

[Crystalyzer]

LB

When I did this initially I entered the formula as follows:

{Prospects.Owner} <> "Joe" or isnull({Prospects.Owner})

When I reversed the order (to what you suggested) I got the desired result.

isnull({Prospects.Owner}) or {Prospects.Owner} <> "Joe"

I am confused as to why this would be. Can you clarify?


Thanks and best regards,
-Lloyd

 

[midearth]

I've had some screwy instances where CR doesn't treat <> correctly for string fields. Try:

not({Prospects.Owner} = "Joe")

 

[lbass]

Whenever you test for nulls, you must do this first, i.e., isnull() must be the first clause in the formula. Otherwise, it doesn't capture the nulls.

-LB

 

[Crystalyzer]

Thanks again LB. Star for you!

Thanks and best regards,
-Lloyd