I'm hoping this is a simple problem for someone.
I'm trying to display a phone number on my report. The number is stored in a table with no formatting at all, just numbers. I've applied an input mask to my report in order to display the phones correctly, but it isn't working quite right.
If a 10 digit number is stored my report shows the number correctly - (757)555-1212, but if a 7 digit number is stored without the area code then the mask just displays the raw number without the dash, 5551212.
Here is the input mask I'm currently using, !(999) 000-0000;;_
Any ideas? Maq![[americanflag] [americanflag] [americanflag]](/data/assets/smilies/americanflag.gif)
<insert witty signature here>
I'm trying to display a phone number on my report. The number is stored in a table with no formatting at all, just numbers. I've applied an input mask to my report in order to display the phones correctly, but it isn't working quite right.
If a 10 digit number is stored my report shows the number correctly - (757)555-1212, but if a 7 digit number is stored without the area code then the mask just displays the raw number without the dash, 5551212.
Here is the input mask I'm currently using, !(999) 000-0000;;_
Any ideas? Maq
![[americanflag] [americanflag] [americanflag]](/data/assets/smilies/americanflag.gif)
<insert witty signature here>