Suppress Text based on condition 1

[Nerdhurd]

Howdy folks,

Im working in crystal reports 8.5 reporting through an ODBC connection to a progress database. Im trying to create a formula that will supress the email address if the rolecode does not equal UPS. I came up with this but im getting errors:

if {TableCnt.RoleCode} = "UPS"
then print "{TableCnt.EMailAddress}";

 

[Naith]

Right click the email address, go to Format, click the button next to Suppress, and insert this:

if {TableCnt.RoleCode} = "UPS"
then false

Naith

 

[Nerdhurd]

Thanks! That worked excellent!

 

[rosemaryl]

Actually you don't have to put in an if then ... you can just enter:

{TableCnt.RoleCode} = 'UPS'

When you click on Suppresion x-2 formula button. It is basically saying, Suppress When? And you can respond with just the condition.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[lbass]

I think Ro means:

{TableCnt.RoleCode} <> 'UPS'

-LB

 

[rosemaryl]

Dear LB,

Thank you ... for the catch...

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762