Page 2 of 3

Re: number format on reports

Posted: Thu Nov 26, 2020 2:32 pm
by admin
Is the decimal point (at least) working?

It does now for me.
format.png
decimal_point.PNG

Steven

Re: number format on reports

Posted: Thu Nov 26, 2020 3:31 pm
by 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!

Re: number format on reports

Posted: Thu Nov 26, 2020 10:15 pm
by 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

Re: number format on reports

Posted: Fri Nov 27, 2020 12:00 am
by 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

Re: number format on reports

Posted: Sat Nov 28, 2020 6:37 pm
by 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

Re: number format on reports

Posted: Sat Nov 28, 2020 7:22 pm
by Janusz
Przechwytywanie.JPG

Re: number format on reports

Posted: Sun Nov 29, 2020 3:05 pm
by 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

Re: number format on reports

Posted: Sun Nov 29, 2020 3:44 pm
by 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

Re: number format on reports

Posted: Sun Nov 29, 2020 6:13 pm
by paulkauz
Janusz wrote: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?

Re: number format on reports

Posted: Sun Nov 29, 2020 6:42 pm
by 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