Hide / Don't hide Decimal Places on reports.

[Paul Dennis]

I have a report which is based on a complex query which using groups, sum,
expressions etc.

On my report I have a field which shows an integer, decimal place and
decimal i.e.

312.44
64.00
123.00
122.22
..
What I would like to do is only show the decimal places if they are greater
than zero, i.e.
312.44
64
123
122.22

Can this be done?

 

[Allen Browne]

What happens if you set the Format property of the text box to:
General Number
You may find that you get more than 2 places when there are additional ones.

Using:
#,##0.##
would drop the digits after the decimal point, but you would still get the
spot.

 

[Paul Dennis]

Tried #,##0.## and it forced everything to 2 decimal points hence you see all
the .00.

However General number did indeed work, or I should say 99%. It hides all
the .00 but when there is a decimal place it shows one 1 place, i.e. 354.67
actual shows as 354.7

It would be good to get the 2 decimal points but this is a great benefit
anyway.