Conditionally suppressing detail section b 1

[Bennie47250]

Using Crystal Version 7.0

In the process of creating a report showing orders entered for a day. I have been asked to highlight the orders that the pricing does not fall within the normal pricing parameters.

To do this I have created a new detail section (section b) and added the necessary formulas to make the determination. We don’t need to see this section unless the order is outside the normal pricing parameters so I have been attempting to format it to conditionally suppress only if it does meet normal pricing. Well, as this has evolved, I find out there are several different times to show this field. One is when the formula that subtracts list price from actual price is not = 0.00 or if there is a discount number if the discount field. That makes me think my formula to conditionally suppress needs to be an IF-Then-Else type but I don’t know the syntax for suppressing. I’m thinking the suppression would go on the Then part of the formula.

I’m using this formula to suppress if there is a discount number

IsNull ({OBCOL199.C1UF6})

And I suppress it using this too.

{@Price Discounted}-{OBCOL296.ACTSP} = 0.0

I just don’t know how to use them together.

Thanks ands sorry for being so long winded but wanted to fully explain it the first time.

 

[MColeman]

If IsNull ({OBCOL199.C1UF6}) = true then true
else
IF {@Price Discounted}-{OBCOL296.ACTSP} = 0.0 then true

 

[Bennie47250]

Wonderful!!

Thanks