number format on reports

[admin]

Is the decimal point (at least) working?

It does now for me.

format.png

decimal_point.PNG

Steven

[Celson]

My results

a) Using decimal format with no grouping:

dasdas1a.png

dasdas1b.png

dasdas1c.png

b) Using currency format we use here in Brazil:

dasdas1d.png

dasdas1e.png

dasdas1f.png

I think after fixed it will allways show 2 decimals, even when it's ,00 - isn´t it?
Thanks!

[admin]

Guys,

I have fixed what I can.

It is on Github now.

Please test it.

I don't understand how to fix the font problem mentioned here...

https://forums.nubuilder.cloud/viewtopic.php?f=19&t=10654

Maybe someone can send me the fixed pdf file.


Steven

[Janusz]

Just tested - and for info - how it looks like with latest nuBuilder standard setting:
And by the way I used umlauts - and looks working.
Maybe the proper fonts to be used - I had some issues in the the past with Polish language and only 2 type of fonts were supporting special characters.

std.JPG

AND to mention if someone wants to use any other format it can be easily created with SQL using FORMAT and CONCAT functions so here belowe the other possible notation with minus in different place:

sql.JPG

Przechwytywanie.JPG

[paulkauz]

Bildschirmfoto 2020-11-28 um 18.18.51.png

Bildschirmfoto 2020-11-28 um 18.18.51.png

Bildschirmfoto 2020-11-28 um 18.18.51.png

[Janusz]

Przechwytywanie.JPG

[paulkauz]

Thanks, now the numbers with signs "Currency symbols" do work for me as well.
Those without currency symbols do not work at all, regardless if they have decimals or not.
They show up on the reports the wrong way.

wrong result.png

[Janusz]

just done short test with new install from Sourceforge and looks like working on different formats:
Question if the minus is properly formatted - but there are many standards and for some it might be fine and for some maybe not.
What do you mean by "without signs" - is it just positive numeric value?

Przechwytywanie.JPG

Przechwytywanie2.JPG

[paulkauz]

just done short test with new install from Sourceforge and looks like working on different formats:
Question if the minus is properly formatted - but there are many standards and for some it might be fine and for some maybe not.
What do you mean by "without signs" - is it just positive numeric value?

Przechwytywanie.JPG

Przechwytywanie2.JPG

I have edited my earlier post. Please try biger numbers with separators to check if they work for you?

[Janusz]

Thanks, now the numbers with signs "Currency symbols" do work for me as well.
Those without currency symbols do not work at all, regardless if they have decimals or not.

YES - I see now - and to confirm I have the same problem here.

SO if the new format is created and the signs /Currency symbol is not defined (left blank) then the format is not working well on the reports.

The first sample belowe is with format: CHF 1'000.00
and the second with format: 1'000.00 (defined without currency)

case1.JPG

case2.JPG

and for example on the Browse Form - the format without currency symbol - works OK

case3.JPG