jasper reports - How to invert the comma and dot when number formatting

Question

The numbers in my report are visualized like this : 123,456.00

I'm trying to get the number visualized like this instead: 123.456,00

I know that I should use the patterns in iReport but I am not able to find the right pattern.

Answer 1

More then pattern problem this seems to be a Locale problem.

You are using an Locale as US and you like to use a Locale as example ITALY

To set desired Local on report generation pass it as a parameter with the key JRParameter.REPORT_LOCALE:

Map<String,Object> params = new HashMap<String,Object>(); 
params.put(JRParameter.REPORT_LOCALE, Locale.ITALY); 
JasperFillManager.fillReportToFile(jasperReport, params); //Example of fill method use your own...

To set it inside of the IDE, in ireport

Window>>Options>>Compilation and execution: Report Local

In jaspersoft-studio

Window>>Preferences>>Report Execution: Locale