Hello I am trying to format the phone number field in Reporting services so it looks like (111)444-2222, but for some reason its not coming out like that can anyone help please??

Check this out - http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/45ee045b-48c0-47ca-9ab3-94c80219dd40

Hi desireemm1, Thanks for the question ans Shahfaisal’s reply. Also try to use below expression: ="(" & Left("1114442222",3) & ")" & Mid("1114442222",4,3) & "-" & Right("1114442222",4) The effect just like this: Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.