Try using TRANSFORM().

>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.