Community
Showing results for 
Search instead for 
Do you mean 
Reply

Custom Report Field

Copper Contributor
Posts: 41
Country: United States

Custom Report Field

I'm trying to create a custom field in a report which will combine two phone number fields.  I understand how this works with string fields like:

 

City&", "&State

 

However I don't know how to concatenate two phone number fields

 

If Phone2 = NULL THEN

customPhone.Text = Phone1

Else

customPhone.Text = Phone1&" or "&Phone2

End If 

 

Is the error a result of phone fields being integers? If so, how would I code this to run properly?

 

Chris 

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Custom Report Field

Off hand the script looks valid. You'll have to debug the script. For example does a phone field display in a custom field?
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129