Last post Jun 13, 2009 05:22 AM by gl@574
Jun 13, 2009 05:22 AM|gl@574|LINK
Recently I'm working on RDLC reports.While applying format to a text box I got problem.
The scenario is as follows:
There is a field called PHONENUMBER in the format (613)215-4567 and which is of type CHARACTER.
I'm getting the phonenumber as 6132154567 from database.Hence I want to apply the format style so as to get the correct format while displaying.
Until now I'm doing it like:
1.Converting the phonenumber from character to double
2.Then applying the format thru properties of textbox by giving like (000)000-0000.
Is there any other direct function or format to convert directly from character type of phonenumber to the above mentioned format(displayed in bold format).
Thanks In Advance