>>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])
>
Now I remember. It was RTRIM function with the additional parameter! Duh... <g>
If it's not broken, fix it until it is.
My Blog