General information
Category:
Reports & Report designer
Title:
Mask for output field
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only