>Hello.
>
>I have a field like this Cantidad n(16,6)
>
>sometimes the user writes 1345.9 4505.103 5413.44
>
>but when I print the field in the report writer the output is
>
>1,345.900000
>4,505.103000
>5,413.440000
>
>I don't want to show the last zeroes in the decimal part.
>
>I've been trying to do that with Transform but I can't find a way.
>
>c.x.
? RTRIM(TRANSFORM(YourField,[9,999,999,999.99999]),1,[0])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
