Conditionally suppressing

[Bennie47250]

Using Crystal Version 7.0

Still having problems so I’m posting this again

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 if it does meet normal pricing.

There are two unique conditions where this section should be shown

The first condition is if the results of the formula that subtracts list price from actual price is not = to 0. I’m using this formula in the suppress condition (X-2) “if {@Price Discounted}-{OBCOL296.ACTSP} = 0 then true” These orders may or may not have a {@LenghtC1UF6} <> 0

The other condition is if a field that determines the length of discount authorization number. If the length of the field is <>0, then it should be shown. I’m using this formula in the suppress condition (X-2) “if {@LenghtC1UF6} = 0 then true”

We have some orders that the will have a difference in the price and the length of the field =0. These are the orders that I’m not able to show when I try to use both formulas together like this “if {@LenghtC1UF6} = 0 then true Else if {@Price Discounted}-{OBCOL296.ACTSP} = 0 then true” This formula only shows the orders that have a {@LenghtC1UF6}

Thanks for the help.

 

[vidru]

Why not just:

{@LenghtC1UF6} = 0 and {@Price Discounted}-{OBCOL296.ACTSP} = 0

It will evaluate to true if it meets both criteria, and false if it fails either.

-dave

 

[Bennie47250]

Tried this but could not get it to work. However as a work around, I created a new field that adds these fields together and then suppress the section based off this value.