Record Selection based on Condition

[tyfish]

I want to base my selection on one condition which is based if another condition is true.
if any of these are conditions are met I do not want to use the record. I am not sure on how to do this with crystal select expert. Any Help would be greatly appreciated.
example below:

(if {UT001.AMATNB} = 9 and
{ut001.ama9nb} is not one of [2,3,4])
(If {UT001.AMATNB} = 11 and
{ut001.ama9nb} is not one of [1,2,3,5])
(If {UT001.AMATNB} = 12 and
{ut001.ama9nb} is not one of [1,5])
(If {UT001.AMATNB} = 13 and
{ut001.ama9nb} is not one of [3,5])

Thank you in advance

Ty

 

[synapsevampire]

You pretty much have it I think:

(if {UT001.AMATNB} = 9 and
not({ut001.ama9nb} in [2,3,4])
and
etc.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[tyfish]

Thank you for the quick response!

I tried the 'if' statement and it is asking for the 'then' to complete the statement.

 

[synapsevampire]

Sorry, remove the IF.

({UT001.AMATNB} = 9 and
not({ut001.ama9nb} in [2,3,4])
OR
...

Note the use of OR and the parens.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com