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 https://github.com/QuilhaSoft/JasperPHP/blob/c1637797822f1e4587e9fce16da1e87ed08ee568/src/Report.php#L454

[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