SELECTION condition

[ricolame]

Hi folks,

I'm facing a weird scenario while using SELECTION formula.

I've a select condition such that {INVENTORY_TYPE.CLASS}<>"A". The only values in CLASS is A,I and R.

Now, I changed the formula to

{INVENTORY_TYPE.CLASS} ="I" and
{INVENTORY_TYPE.CLASS} ="R"

and it will never work. My data becomes zero.

If I use a single condition such as
{INVENTORY_TYPE.CLASS} ="I" it will work again.


Can anyone guide me in solving this ? Thanks a million. It's driving me nuts!

 

[dgillz]

Think about this, there is no way a single record can have BOTH "I" and "R" as its value, therefore your formula:

{INVENTORY_TYPE.CLASS} ="I" and
{INVENTORY_TYPE.CLASS} ="R"

Will ALWAYS evaluate to false and you get zero records. Change the and to or, and you should get the desired results.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[Madawc]

Try {INVENTORY_TYPE.CLASS} in ["I", "R"]

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

 

[ricolame]

argh stupid me ! tks for that. time to wake up my mind!