number format on reports

Questions related to using nuBuilder Forte.

Re: number format on reports

Unread postby admin » Thu Nov 26, 2020 11:02 pm

Is the decimal point (at least) working?

It does now for me.

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


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



Steven
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Re: number format on reports

Unread postby Celson » Fri Nov 27, 2020 12:01 am

My results

a) Using decimal format with no grouping:

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


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


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


b) Using currency format we use here in Brazil:

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


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


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


I think after fixed it will allways show 2 decimals, even when it's ,00 - isn´t it?
Thanks!
Celson
 
Posts: 36
Joined: Wed Jan 27, 2016 9:05 pm

Re: number format on reports

Unread postby admin » Fri Nov 27, 2020 6:45 am

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
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Re: number format on reports

Unread postby Janusz » Fri Nov 27, 2020 8:30 am

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 230 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 230 times

Przechwytywanie.JPG
Przechwytywanie.JPG (25.47 KiB) Viewed 230 times
If you like nuBuilder, please leave a review on SourceForge
Janusz
nuBuilder Team
 
Posts: 446
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland
nuBuilder Version: 4.5

Re: number format on reports

Unread postby paulkauz » Sun Nov 29, 2020 3:07 am

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 225 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 225 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 225 times
Attachments
Bildschirmfoto 2020-11-28 um 18.28.29.png
On reports, the nubuilder uses formats which are not defined in the format builder
Bildschirmfoto 2020-11-28 um 18.28.29.png (26.08 KiB) Viewed 225 times
Bildschirmfoto 2020-11-28 um 18.29.33.png
I still can't create formats with decimals
Bildschirmfoto 2020-11-28 um 18.29.33.png (27.05 KiB) Viewed 225 times
If you like nuBuilder, please leave a review on SourceForge
paulkauz
 
Posts: 30
Joined: Sat Oct 31, 2020 3:38 am

Re: number format on reports

Unread postby Janusz » Sun Nov 29, 2020 3:52 am

Przechwytywanie.JPG
Przechwytywanie.JPG (18.63 KiB) Viewed 222 times
If you like nuBuilder, please leave a review on SourceForge
Janusz
nuBuilder Team
 
Posts: 446
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland
nuBuilder Version: 4.5

Re: number format on reports

Unread postby paulkauz » Sun Nov 29, 2020 11:35 pm

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 212 times
Attachments
wrong result.png
wrong result.png (17.92 KiB) Viewed 212 times
Last edited by paulkauz on Mon Nov 30, 2020 2:40 am, edited 3 times in total.
If you like nuBuilder, please leave a review on SourceForge
paulkauz
 
Posts: 30
Joined: Sat Oct 31, 2020 3:38 am

Re: number format on reports

Unread postby Janusz » Mon Nov 30, 2020 12:14 am

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 214 times

Przechwytywanie2.JPG
Przechwytywanie2.JPG (20.89 KiB) Viewed 214 times
If you like nuBuilder, please leave a review on SourceForge
Janusz
nuBuilder Team
 
Posts: 446
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland
nuBuilder Version: 4.5

Re: number format on reports

Unread postby paulkauz » Mon Nov 30, 2020 2:43 am

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?
If you like nuBuilder, please leave a review on SourceForge
paulkauz
 
Posts: 30
Joined: Sat Oct 31, 2020 3:38 am

Re: number format on reports

Unread postby Janusz » Mon Nov 30, 2020 3:12 am

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 211 times
case2.JPG
case2.JPG (12.57 KiB) Viewed 211 times

and for example on the Browse Form - the format without currency symbol - works OK
case3.JPG
case3.JPG (28.8 KiB) Viewed 210 times
If you like nuBuilder, please leave a review on SourceForge
Janusz
nuBuilder Team
 
Posts: 446
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland
nuBuilder Version: 4.5

PreviousNext

Return to General

Who is online

Users browsing this forum: steven and 31 guests