CODEWITHSUNDEEP
pentahonumber-formattingpentaho-report-designer
ferpinan
ferpinan

Reputation: 171

Incorrect number formatting in Pentaho Report

I'm using Pentaho Report designer 3.9 for a legacy project that has some reports that should support different languages (English, Spanish and Euskera).

I have a problem with the number formatting. While in English and Spanish numbers show properly (#.###,## in Spanish and #,###.## in English), in Euskera numbers are shown the same way that are shown in English, but they should be shown the same as Spanish.

I've tried setting the language as eu, as eu_ES and es-ES but I haven't suceeded.

Have anyone had a similar problem?

Thank you very much for your help.

Upvotes: 2

Views: 774

Answers (2)

R. Weber
R. Weber

Reputation: 1

I had this problem when trying to use the mask in the Text Output to generate a CSV, the execution was ignored the mask to convert "0.00" to "0,00". I found that the problem was in the Oracle sql query with a TO_CHAR ( ) in the column, which caused masks to be ignored.

Upvotes: 0

Helping Hand..
Helping Hand..

Reputation: 2440

Number format field will not directly work for multi-language report. In my current project we are using MySQL database and handling multi-language number format at query level and using text-field displaying it into report.

Upvotes: 1

Related Questions