Number and date format

[allgood]

What is the best way (is supported any) to format monetary numbers and dates on the report?

[Rctnet]

for example
date fields use this dd/MM/yyyy
numbers fields use #.##0,00
set this in pattern field of textfield properties

I will create a page with all supported formats and post in jasperphp.com

[Rctnet]

you can check all suported formats in

JasperPHP/src/Report.php

Line 454 in c163779

public static function formatText($txt, $pattern) {

[Rctnet]

https://jasperphp.com/documentation/supported-date-and-numbers-formats/

[gamadoleo]

A doubt, I know there is the numeric format of latin formatting, but this does not maintain compatibility with jasper studio, but I know that when putting the latin format in jasperphp it works which is a beauty, but I've always been pressing on compatibility, so a question wouldn't a way to define the thousands and decimal separators be more coherent? or even set based on a language?

[gamadoleo]

the studio has the unique pattern formatting but it identifies the language and makes the adjustment automatically