How to set up thousand separators as a quote in Jaspersoft studio

[philippe.bocquet]

I'd like to have this presentation of the amounts in my report : 1'635'133,25

The pattern #,##0.00# does not allom me to have the format 1'635'133,25

Any idea ?

Thank you

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

[Anuja Vilas Bhujbal]

Hello,

 

The thousand separator is evaluated by Java as per the user locale. Please refer to the below link for more details regarding the Java formatters. 

 

https://docs.oracle.com/javase/8/docs/api/java/text/DecimalFormat.html

 

For example, if you have the pattern #,##0.00 set for the value of your field and your user uses the locale de_CH(which uses the ' as the thousands separator by default), then you will see the value of that field like  1'635'133. You can test this by adding the below property in your report to set the locale of the report to de_CH.

 

    <property name="net.sf.jasperreports.default.locale" value="de_CH"/>