My data comes from a SQL database, and I have a phone field with a default format of 111-111-1111.  I want to change this format to (111) 111-1111. 

 

I assume it has something to do with the split() method, but I'm not sure where or how to apply it in Crystal Reports XI (I'm new to Crystal Reports in general).  Help would be greatly appreciated.

 

Thank you,

 

Hammerklavier 

 

Is it possible to use variables for formula fields in the Formula Workshop?  I was envisioning using the split() method to create an array with the different pieces of the phone number.  It doesn't look like this will be necessary here, but it's something I've been wondering about with Crystal Reports XI.