number format on reports

[admin]

Is the decimal point (at least) working?

It does now for me.

format.png (72.61 KiB) Viewed 228 times

decimal_point.PNG (59.67 KiB) Viewed 228 times

Steven

[Celson]

My results

a) Using decimal format with no grouping:

a) PDF

dasdas1a.png (59.75 KiB) Viewed 226 times

b) Edit Screen

dasdas1b.png (32.38 KiB) Viewed 226 times

c) Report Designer

dasdas1c.png (32.21 KiB) Viewed 226 times

b) Using currency format we use here in Brazil:

Report Designer - Changed currency format

dasdas1d.png (4.1 KiB) Viewed 224 times

PDF with anoter currency format

dasdas1e.png (21.82 KiB) Viewed 224 times

Edit Screen with anoter currency format

dasdas1f.png (8.94 KiB) Viewed 224 times

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.com/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 (34.14 KiB) Viewed 220 times

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 (25.85 KiB) Viewed 220 times

Przechwytywanie.JPG (25.47 KiB) Viewed 220 times

[paulkauz]

The issue with the Umlaute in the labels works now for me

Bildschirmfoto 2020-11-28 um 18.18.51.png (51.07 KiB) Viewed 215 times

The issue with the Umlaute in the labels works now for me

Bildschirmfoto 2020-11-28 um 18.18.51.png (51.07 KiB) Viewed 215 times

The issue with the Umlaute in the labels works now for me

Bildschirmfoto 2020-11-28 um 18.18.51.png (51.07 KiB) Viewed 215 times

[Janusz]

Przechwytywanie.JPG (18.63 KiB) Viewed 212 times

[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.

defined format.png (26.52 KiB) Viewed 202 times

[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 (23.73 KiB) Viewed 204 times

Przechwytywanie2.JPG (20.89 KiB) Viewed 204 times

[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 (13.35 KiB) Viewed 201 times

case2.JPG (12.57 KiB) Viewed 201 times

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

case3.JPG (28.8 KiB) Viewed 200 times