Number formatting in reports
On screen, when large numbers are un-formatted they are quite difficult to read:
What would be really useful and user friendly would be the option to apply number formats for numeric fields in reports. In particular, thousand separators is what I need.
For example, I would like to format the numbers
1200000
874000
2000000
like this:
1,200,000
874,000
2,000,000
It seems to me that a reasonable place to put this is under Report Settings -> Column Properties.
There is a work-around which involves converting the number to a string and introduce the formatting into the string. However, although this solution solves the formatting problem (clumsily), it also introduces the problem that the data is no longer a number, and therefore sorting, adding, searching does not work. So this work-around is not that useful.
(Also, it would be nifty to also introduce a a setting for Left/Right/Center alignment of a column.)