I can't seem to find any information on displaying a phone number in
crystal reports in the (###) ### - #### format instead of 1234567891
when making a report. Can anyone point this out to me?
Printable View
I can't seem to find any information on displaying a phone number in
crystal reports in the (###) ### - #### format instead of 1234567891
when making a report. Can anyone point this out to me?
In crystal reports, create a formula and try the picture function found under "Additional functions"
Example: Picture ({customer.phone},"(xxx) xxx-xxxx" )
If the string is 1234567891, then the outcome will be (123) 456-7891. This will work.
OR
you can use the Mid function.
Example: "(" + Mid ({Customer.phone},1 ,3 ) + ") " + Mid ({Customer.phone},4 ,3 ) + "-" + Mid ({Customer.phone},7 ,4 )
If the string is 1234567891, then the outcome will be (123) 456-7891. This will also work.
GaryCaspelich