Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field Format
Message
De
13/02/2015 11:11:31
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Field Format
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01615297
Message ID:
01615297
Vues:
70
I have a report with a field that uses a variable with a numeric datatype as it's "Expression"
SUM Cost ALL FOR Distr TO m.nTotalDistrCost
m.nTotalDistrCost = ROUND(m.nTotalDistrCost,2)
When I run the report (set enginebehavior = 80) and I have the format set as Numeric with the currency check box "checked" the value displays with as many trailing zeros (0) as the field box is wide. What gives?

How do I get it to display like $199.99? as opposed to $199.990000000000. I've done a Format Expression as $9,999,999.99 which displays as $ 199.99 (a whole bunch of space between the $ and the number)
Thanks
Jon
Non-MVP Non-MCP Non-MCSE

Visual FoxPro, What else is there?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform