Fast Report Phone #

Hi Frank,
When MVD saves the phone number,  it is saved 'raw' - the formatting is only applied when you run your program (see screenshot 1) but the formatting doesn't carry over in to FastReport.
There are a couple of options but for me, the easiest (and therefore the best (LOL!)) would be a calculated field which can be taken across to the report.
It has the added advantage in that you can also use the calculated field to display in your tablegrid so you see the phone with its formatting there as well.
Please see the attached as an example.
Derek.

Derek,

Here's the SQL error message. I could only add one file to my last message.

Thanks,
Frank

Brian,
Thanks for your reply
-
I added a calculated field named calcCellPhone to the Contacts table.  When I go to open up the Contacts Form I still get the same error.
-
FYI I also have a cell phone field in the Users table so eventually I would like to format that field like the calcCellPhone in the contacts table.
-
From my trial and error it appears that if I add a new calculated field to either Users or Contacts it fails.  Even if I don't do anything with the new field.  Just adding it to an existing table makes it fail.
-
I have a lot of test data in my tables.  Could that have any impact on adding a new field?
-
Thanks, Frank

If you copy the calculated Derek and I used, we use phone there for it is the field on our database. on User for Derek. on Contacts for me. You need to replace it of the field on your table. in your case,  change phone from User's calculated to CellPhone and change phone from the Contact's calcCellPhone to cCellPhone.

For User, something like

'('||substr(CellPhone,1,3)||')'||substr(CellPhone,4,3)||'-'||substr(CellPhone,7,4)

and for Contacts

'('||substr(cCellPhone,1,3)||')'||substr(cCellPhone,4,3)||'-'||substr(cCellPhone,7,4)

Adding calculated fields or other fields won't affect your current data. MVD will automatically populate the table with your existing records