[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

What is the code structure to format a numeric value as a phone number in a rdlc

Posted on 2008-10-23
3
Medium Priority
?
499 Views
Last Modified: 2013-11-26
I am trying to format a numeric value retrieved from an data table, so that it will display as a phone number in a rdlc. I am using the microsoft report viewer and creating the rdlc using the drag method from the available fields in the data table.
rdlc-screen-view.bmp
0
Comment
Question by:gregoronovich
1 Comment
 
LVL 3

Accepted Solution

by:
bigdaddyz99 earned 200 total points
ID: 22809634
I use something similar to this from
http://www.themssforum.com/SVCS/format-phone/
= Format(Convert.ToDouble("90155585850000"), "(###) ###-#### 'Ext.' ####") 
 
'or use a regular expression, sth like 
 
=System.Text.RegularExpressions.Regex.Replace(Fields!phone.Value, 
"(\d{3})(\d{3})(\d{4})", "($1) $2-$3") 

Open in new window

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question