Page 2 of 3

Re: number format on reports

Unread postPosted: Thu Nov 26, 2020 11:02 pm
by admin
Is the decimal point (at least) working?

It does now for me.

format.png
format.png (72.61 KiB) Viewed 230 times


decimal_point.PNG
decimal_point.PNG (59.67 KiB) Viewed 230 times



Steven

Re: number format on reports

Unread postPosted: Fri Nov 27, 2020 12:01 am
by Celson
My results

a) Using decimal format with no grouping:

dasdas1a.png
a) PDF
dasdas1a.png (59.75 KiB) Viewed 228 times


dasdas1b.png
b) Edit Screen
dasdas1b.png (32.38 KiB) Viewed 228 times


dasdas1c.png
c) Report Designer
dasdas1c.png (32.21 KiB) Viewed 228 times


b) Using currency format we use here in Brazil:

dasdas1d.png
Report Designer - Changed currency format
dasdas1d.png (4.1 KiB) Viewed 226 times


dasdas1e.png
PDF with anoter currency format
dasdas1e.png (21.82 KiB) Viewed 226 times


dasdas1f.png
Edit Screen with anoter currency format
dasdas1f.png (8.94 KiB) Viewed 226 times


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

Re: number format on reports

Unread postPosted: Fri Nov 27, 2020 6:45 am
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.com/viewtopic.php?f=19&t=10654

Maybe someone can send me the fixed pdf file.


Steven

Re: number format on reports

Unread postPosted: Fri Nov 27, 2020 8:30 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
std.JPG (34.14 KiB) Viewed 222 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
sql.JPG (25.85 KiB) Viewed 222 times

Przechwytywanie.JPG
Przechwytywanie.JPG (25.47 KiB) Viewed 222 times

Re: number format on reports

Unread postPosted: Sun Nov 29, 2020 3:07 am
by paulkauz
Bildschirmfoto 2020-11-28 um 18.18.51.png
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 217 times

Bildschirmfoto 2020-11-28 um 18.18.51.png
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 217 times

Bildschirmfoto 2020-11-28 um 18.18.51.png
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 217 times

Re: number format on reports

Unread postPosted: Sun Nov 29, 2020 3:52 am
by Janusz
Przechwytywanie.JPG
Przechwytywanie.JPG (18.63 KiB) Viewed 214 times

Re: number format on reports

Unread postPosted: Sun Nov 29, 2020 11:35 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.
defined format.png
defined format.png (26.52 KiB) Viewed 204 times

Re: number format on reports

Unread postPosted: Mon Nov 30, 2020 12:14 am
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
Przechwytywanie.JPG (23.73 KiB) Viewed 206 times

Przechwytywanie2.JPG
Przechwytywanie2.JPG (20.89 KiB) Viewed 206 times

Re: number format on reports

Unread postPosted: Mon Nov 30, 2020 2:43 am
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

Unread postPosted: Mon Nov 30, 2020 3:12 am
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
case1.JPG (13.35 KiB) Viewed 203 times
case2.JPG
case2.JPG (12.57 KiB) Viewed 203 times

and for example on the Browse Form - the format without currency symbol - works OK
case3.JPG
case3.JPG (28.8 KiB) Viewed 202 times