Number formatting

Questions related to nuBuilder Forte Reports and the Report Builder.

Number formatting

Postby KEE » Tue Feb 27, 2018 3:45 am

Two questions on the Reports.

I create button in Edit form to running a report. Why can't use the Hash Cookie record_id when using the procedure to create a temporary table? I run nuHash() inside code, record_id is empty.

Strangely behaves number formatting (see below).

Thank you!
Konstantin
Attachments
object1002.png
object1002.png (32.8 KiB) Viewed 2856 times
result.png
result.png (8.72 KiB) Viewed 2856 times
KEE
 
Posts: 12
Joined: Sat Feb 24, 2018 9:47 pm

Re: Number formatting

Postby admin » Wed Feb 28, 2018 11:57 am

KEE,

1.- I have fixed that now (on Github), #RECORD_ID# should work for Reports. Let me know if it works for you.

2. Can you give me just 1 example of a format and a value I can test? - I don't quite understand your examples.

Steven
admin
Site Admin
 
Posts: 3153
Joined: Mon Jun 15, 2009 9:53 am

Re: Number formatting

Postby KEE » Wed Feb 28, 2018 3:44 pm

Thanks Steven!
Here is the database with an example of a formatting error.
Konstantin
Attachments
example.sql.zip
(244.06 KiB) Downloaded 47 times
KEE
 
Posts: 12
Joined: Sat Feb 24, 2018 9:47 pm

Re: Number formatting

Postby toms » Wed Feb 28, 2018 3:59 pm

KEE,

I think it'd be easier for us if you could post just 3 screenshots. Like...

- showing the number format you set
- what is displayed
- what you expect to be shown
toms
 

Re: Number formatting

Postby KEE » Wed Feb 28, 2018 7:22 pm

toms,
here's how it looks:
Attachments
format.png
format.png (7.43 KiB) Viewed 2838 times
reportdesigner.png
reportdesigner.png (20.3 KiB) Viewed 2838 times
result.png
result.png (11.4 KiB) Viewed 2838 times
expectation.png
expectation.png (8.75 KiB) Viewed 2838 times
KEE
 
Posts: 12
Joined: Sat Feb 24, 2018 9:47 pm

Re: Number formatting

Postby KEE » Wed Feb 28, 2018 7:25 pm

Steven, #RECORD_ID# works for Reports fine, thanks!
KEE
 
Posts: 12
Joined: Sat Feb 24, 2018 9:47 pm

Re: Number formatting

Postby KEE » Wed Feb 28, 2018 7:51 pm

Another problem. Date format dd.mm.yyyy shows one digit of the month, and I need two ...
Attachments
reportdesigner2.png
reportdesigner2.png (14.68 KiB) Viewed 2837 times
result2.png
result2.png (2.54 KiB) Viewed 2837 times
expectation2.png
expectation2.png (2.18 KiB) Viewed 2837 times
KEE
 
Posts: 12
Joined: Sat Feb 24, 2018 9:47 pm

Re: Number formatting

Postby admin » Wed Feb 28, 2018 8:03 pm

KEE,

I have put the fix on Github.

Let me know if it works for you.

Steven
admin
Site Admin
 
Posts: 3153
Joined: Mon Jun 15, 2009 9:53 am

Re: Number formatting

Postby admin » Wed Feb 28, 2018 8:22 pm

KEE,

I have put the fix on Github - (both number and date).

Let me know if it works for you.

Steven
admin
Site Admin
 
Posts: 3153
Joined: Mon Jun 15, 2009 9:53 am

Re: Number formatting

Postby KEE » Fri Mar 02, 2018 7:48 pm

Date format and number format works fine.
Thanks for the quick fix!
KEE
 
Posts: 12
Joined: Sat Feb 24, 2018 9:47 pm

Next

Return to Reports