remove "locale" from currency format

Posted on April 10, 2019 at 10:36am

I recently updated to JS 6.6.0 and trying some reports I noticed some extra characters in currency columns like ARS 1.234,00 when the usual and what I want is $1.234,00 or €1.234.00 (if I change to location/region of the OS)

Running the preview (JasperStudio) It doesn't change the ¤ for anything and compiling and running through my app + payara it shows the extras ARS

I am using Payara 4, on Windows 10

The pattern is exactly the same as always ¤#,##0.00 

Jaspersoft® Studio
firuzzz's picture
firuzzz
281
Joined: May 17 2012 - 5:03am
Last seen: 1 year 7 months ago

2 Answers:

Posted on April 25, 2019 at 3:34am

Thanks but it was definitely something related Payara, a JVM property that I added

-Duser.language=en (this is because the translation of logs exception to my OS/Region language (Spanish) is too bad, so I wanted all in English)

having to change hundreds of report couldn't be the solution

firuzzz's picture
firuzzz
281
Joined: May 17 2012 - 5:03am
Last seen: 1 year 7 months ago
Posted on April 10, 2019 at 3:08pm

Instead of specifying pattern, try putting something like below in the expression. If the result is the same, it's probably the Payara 4 application. Should contact them.

new DecimalFormat("¤#,##0.00").format($F{amount})

hozawa's picture
hozawa
190747
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
Feedback
randomness