Showing results for 
Search instead for 
Do you mean 

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


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?



Platinum Elite Contributor
Posts: 6,753
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