Wednesday, June 12, 2013

Format a phone number in Report Builder 3.0

Problem
I need to format a numeric phone number to the format (###) ###-#### Ext. #### on a Reporting Services report in Report Builder 3.0

Solution 

Format(Convert.ToDouble(Fields!Phone.Value), "(###) ###-####  'Ext.' ####")

reference
http://www.developmentnow.com/g/115_2013_1_0_0_646635/format-phone-numbers.htm

No comments:

Post a Comment

There was an error in this gadget