Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Format mask for numbers
Message
From
02/12/2008 20:16:21
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Format mask for numbers
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01365281
Message ID:
01365281
Views:
83
I have a need to display a numeric field on the report with options to have no decimals, 2 decimals, 3 decimals or more.
Currently I'm using the format mask in the field expression to do this but unable to put a iif() condition on the format mask to dynamically change the format mask based on a public variable to decide on how many decimal points the format mask should have.

Is there a way to do this?

Thanks in advance.
Yau
Next
Reply
Map
View

Click here to load this message in the networking platform