Can I change the text field in a Crysatl Report based on other data 1

[suzyg]

Hi there,

I am trying to change the text lables on a Crystal Report (v. 8.5). I have two companies one is US and the other is Canadian and some of the text labels on my report need to change depending on which company the report is for. I need to use the same report. An example would be if the company is 'Canada' use the label GST if the company is 'US' use the labe TAX. Is this possible and if so how?

Thanks!!!!!!!

 

[AndyMc]

suzyg,

Create a formula to use in place of the text field.

//@taxLabel
if {table.countryCode} = "US"
"Tax"
else
"GST"


Andy

 

[AndyMc]

I forgot the "then":

//@taxLabel
if {table.countryCode} = "US" then
"Tax"
else
"GST"


Andy