>>My report select the QTY field but my data is having 4 decimal places
>>I want it to auto remove the last 0 decimal places
>>e.g.
>>my data 152445.5230 display as 152,445.523
>>my data 152445.5000 display as 152,445.5
>>my data 152445.0000 display as 152,445
>>my data 152445.5237 display as 152,445.5237
>
>But that's not what you said in your original message.
>Try TRANSFORM( QTY) in your report field. It's supposed to remove trailing 0 from numeric data by default.

I know the help says that, but TRANSFORM() hasn't worked that way for a long time. You'll still see the trailing 0's.

For VFP9, the help has been modified to state:
"Removes trailing zeros from the decimal portion of a numeric value when all the numbers following the decimal point are zeros."