Currency pattern

[forstera]

Hello all,

I'm completely new in jasper report so ... I've the following problem. In my report, I've a currency field. When I click on pattern to select the good one, the amount format is displayed correctly (in my case, 1'123.40) (I'd like to display the thousands separator). But when I save the report and apply it, the thousand separtor is not ' but , . In the same way, if I choose the currency pattern, the sample displayed is correct (in my case Sfr. 1'234.40) but when the report is saved and applied, the currency become $ 1,234.40.

Don't know what to do to correct that (I'm using jasper report 3.6.0).

Per advance, thanks for your help

 

 

[fishermania]

You could do your formatting in a variable. When displaying it on your report do it as a String and then just replace your commas with ticks.

 

[forstera]

Hello,

Thanks for the idea, looks great. Just have to learn how to do that :)

Thanks again