Every time, without fail, I need to create a phone number on an SSRS report for a client and get stuck with phone formatting. Every time I am searching forums. I thought it would be awesome if it was in some amazing blog that I could visit and copy from each time.
So... here it is, if not for myself, then for others:
In Report Builder or visual studio, add your phone number field to the report.
Right click on that text box where you added the field and click on expression.
Clear the formula box and type in the expression below.
Formula to Use:
=IIF(Fields!Phone.Value Is Nothing, Nothing, IIF(IsNumeric(Fields!Phone.Value), Format(Val(Fields!Phone.Value), "(000) 000-0000"), Fields!Phone.Value))
Note: My field is actually called Phone. If your field is not called phone, you will need to replace it with your phone field name. (Like: Fields!E_T_PHONE_HOME.Value)
Then click on OK at the bottom of the expression box.
Run your report.
Until next time.
Microsoft Dynamics 365 Business Central <br> My Top 10 Favorite Things #5 <br> User Preferences and Personalization <br> Part 1
Microsoft Dynamics 365 Business Central My Top 10 Favorite Things #5- User Preferences- Part 1 Sometimes software has reall...
Summit is my favorite time of the year and I can't believe it is almost upon us. Here is my list of top things not to miss each year. ...
Microsoft Dynamics 365 Business Central My Top 10 Favorite Things #4- Viewing any Business Central Table in the Browser For...
In Dynamics GP, you could always track if an email was sent by visiting the sent box of your inbox after sending the emails. After much r...