Formula help - relates to prior Thread

[cyreports]

This question relates directly to thread767-1616115, in which LBass helped me with. Not sure when I give someone a star if it stops the messages after or not, so just in case I created a new entry. Forgive me if im wrong.

LBass helped me with the following formula:

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

The only issue is I need something similar in my Group 1 Footer. 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?

 

[FireGeek21]

Try the following:

Trim(UCase({Data.ProcCode})) = "PH" or
Trim(UCase({Data.ProcCode})) = "RX"

The other thing you can try is to put the Trim/UCase in a formula field and then call the formula field into the suppression:

Formula_Field = Trim(UCase({Data.ProcCode}))

Suppression would then look like:

{@Formula_Field} = "PH" or
{@Formula_Field} = "RX"

Hope this helps!


FireGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[cyreports]

FireGeek -

Tried both ways and still no luck.

 

[FireGeek21]

If you reverse it and put "RX" first, does it only choose to suppress "RX"?

FireGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[lbass]

Please do not start new threads on the same topic. I just responded to your original thread. The issue is that the suppression formula only reads the last record in the group.

-LB

 

[cyreports]

My apologies on the new thread. I was not sure if it closed the old question out when i gave the star. Thank you.