Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field Format
Message
From
13/02/2015 11:11:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Field Format
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01615297
Message ID:
01615297
Views:
71
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?
Next
Reply
Map
View

Click here to load this message in the networking platform