Selection Formula Help

[TEM3]

Using CR 8.5:

Not only is this selection formula ugly, the last three arguments are ignored -

{ARRESULT.Result} <> "0" or
{ARRESULT.Result} <> "" or
{ARRESULT.Result} <> "False" or
{ARRESULT.Result} <> "Not Performed" or
{ARRESULT.Result} <> "N/A" or
{ARRESULT.Result} <> "Not Applicable";

Is there better way (and a way that will test the last three statements)?

 

[Naith]

Not ({ARRESULT.Result}) in ["0","False","Not Performed","N/A","Not Applicable"]

This is case sensitive, so when you say that some arguments are being ignored, verify that your selection criteria addresses this.

Naith

 

[Naith]

That should be:

Not ({ARRESULT.Result} in ["0","False","Not Performed","N/A","Not Applicable"])

 

[TEM3]

Thanks. It works fine. Question though..... How come this takes care of Null values in {ARRESULT.Result} too? Is that automatic??

 

[Naith]

No.

The only thing I can think of is that you must have Convert Database Null Values to Default checked on in your Options or Report Options, in the File Menu.

To handle nulls otherwise, you'd need to explicitly reference the IsNull function in your formula:

i.e.
Not IsNull({ARRESULT.Result}) and
Not ({ARRESULT.Result}) in ["0","False","Not Performed","N/A","Not Applicable"]

Naith

 

[TEM3]

Yes I do (have Null Values set to default checked). Guess that put's something other than a Null there (like a "0" or something I am filtering for.