Field suppression for two conditions

[xidnad]

I am using Crystal 7.0 and trying to suppress a text field, using the Format Editor, based on two different conditions. The suppression works with either condition but ignores the second condition if I try to use them together. I am trying to use:
{ado.Influ3Code} like "OVL" and {ado.Influ3Percent} = -100 or {ado.UnitType} like "PPAV"
I have also tried
({ado.Influ3Code} like "OVL" and {ado.Influ3Percent} = -100) or {ado.UnitType} like "PPAV"

What am I missing?

Thanks

 

[synapsevampire]

Use more parentheticals to help define what you need, and note that you're using a LIKE condition ithout wildcards, so look at the asterisk I added in there:

(
{ado.Influ3Code} like "OVL"
and
{ado.Influ3Percent} = -100
)
or
(
{ado.UnitType} like "PPAV*"
)

Asterisk added to the like clause, if you want an exact match, use the = not a LIKE.

This appears as though it should work, however you're generally better served to post technical information:

Crystal version
Dtabase/connectivity used
Example data
Expected output

-k

 

[xidnad]

Thanks for your remarks once I made those changes and reversed the order
({ado.UnitType} like "*PPAV*") or({ado.Influ3Code} like "*OVL*" and {ado.Influ3Percent} = -100)
it worked.

 

[synapsevampire]

Odd that reversing the order would have anything to do with it...but Crystal kind be kinda funny at times...

The asterisks are key though if you're doing a LIKE.

Glad that you worked it out.

-k