I want to represent decimal values with two decimal places after comma. If a pass the values to datastore in numeric format only a whole number is shown on report.view.
I use postgreSQL as datasource and have tried to preformat the numbers using postgre built in round function defining 2 decimal places (round(v numeric, s integer) )but it makes no difference.
The only solution that I've found to have the as numbers with two decimal places is to type cast the values to varchar already on SQL query level. (to_char(v numeric::real, '90D99').
This however make it impossible to sum the columns as totals in footer. Aslo when I export such report to excel I will end up having text values on my spreadsheet.
Any recommendations how to do it the right way?
Thank You in advance