Suppress Statement help. 1

[cyreports]

Changing suppression statement on crystal report no error in my formula but it is not working I want it to suppress if the code = PH or RX

({Data.ProcCode}= 'PH' or {Data.ProcCode}= 'RX')

works fine if only {Data.ProcCode}= 'PH', it is when I add the statement to look at the RX also. Any help is appreciated.

 

[lbass]

Your code should work as written unless you have an issue with case or with spaces. Try:

trim(ucase({Data.ProcCode})) in ["PH","RX"]

-LB

 

[cyreports]

You are AWESOME!

 

[cyreports]

LBass -

I am dropping this in my Group Footer suppress statement and for some odd reason its only working when the Proc code = "PH". Any suggestions?

 

[lbass]

The group footer will only be suppressed if the last record in the group is one of those two. Under what conditions do you want it to suppress? Do you mean if the group contains any records with those values you want to suppress?

-LB

 

[cyreports]

LBass -

I want it to suppress the footer if the {Data.ProcCode}= "RX" or "PH". I have two footers Group Footer 1a and 1b. One that should pull a distinct footer when it equals the "RX" or "PH" and when it does not equal these same values.

 

[lbass]

What field are you grouping on?

-LB

 

[cyreports]

{Data.Code} is the field its being grouped on.

 

[lbass]

Which is not the same as {Data.ProcCode}, correct?

-LB