>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.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.