Formulas - Supressing

[vbjohn]

In my formula I have a text message with an error message. I have this on my report. So I went into the features of the formula and I went into the SUPRESS button. I am curious about this one issue....

This is my code for in order to supress:

({@DefComp} < {@75DEFCOMP}) = TRUE OR
({@DefComp} > ({@GrossWages} *.75 ) OR
({@DefComp} > ({@Age} *.75)

Do all of these have to be true in order to work?

Cause on my report this is what I have...

(9360.00 < 11428.08) = True is TRUE
(9360.00 > 9355.52) is TRUE
(9360.00 > 9000) is TRUE

It does not supress the code if there is one FALSE statement in which it should. Why does this happen?

John-

 

[pastasalad]

Can you try taking the '= TRUE' out of the first line? I'm not able to check this at the moment but it may well be knocking out the test processing sequence, and is superfluous in any case.

Let us know if this changes anything.

Regards

Marc

 

[vbjohn]

I just did and still nothing...


Actually what I am getting in the supress statement is:

9360 < 11428.08 True
9360 < 12357.95 True
9360 < 9000 False
or
8750 < 8615.95 False
8750 < 9355.52 True
8750 < 9000 True

So if I am getting at least 1 false then it should not suppress this statement. Why isn't it working?

 

[Madawc]

I think the formulas apply their condition when the test is met. If you have several tests linked by OR, I'd expect suppression to occur if any of them are true.

It's a matter of design philosophy. Your understanding of what Crystal should be doing is no worse than what it's actually doing, it's just not correct for Crystal.

Madawc Williams
East Anglia
Great Britain

 

[vbjohn]

Ohhhh... I just changed the OR to an AND statement. It works fine now. Thanks for your help. I was not thinking correctly.


john-