Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mask for output field
Message
From
13/04/2000 06:37:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Mask for output field
Miscellaneous
Thread ID:
00359161
Message ID:
00359161
Views:
39
Hi all,
How can I set mask for output numeric field in report.
I have numeric field NUMBER(13,3), but in report I use different output mask. Example for this field I use output mask:
a) "999 999 999,999"
b) "999 999 999" (decimal numbers I ignore)
c) "999 999 999,9" (I want show only first decimal number, other I ignore.
All of these examples I use in the same report acording to some flags.
Sample:

"Amout" is this field (Number 13,3) where is depends on unit.
If unit is "piece" show only in format "999 999 999", when is "tonne" show int format "999 999 999,999", ....

... header ....
Name Amount Unit
... start body (records) ...............
Tovar1 45 piece
Tovar2 12 piece
Tovar3 4.125 tonne
Tovar4 3.5 liter
Tovar5 11.3 liter
... end body ...........................

... foother ...


Thank, Martin.
Next
Reply
Map
View

Click here to load this message in the networking platform