Number format in Document - Report

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
KnightWare
Posts: 139
Joined: Sat Feb 10, 2018 12:56 am

Number format in Document - Report

Post by KnightWare »

A numeric attribute has a format defined as 0,0 so that there is a thousands separator (12,557). When attribute is used in a tag for a document report inside a table, it places the comma separator after each numeral in the number (1,2,5,5,7).
BobK
Posts: 544
Joined: Thu Jan 31, 2008 2:14 pm
Location: Cincinnati, Ohio, USA

Re: Number format in Document - Report

Post by BobK »

The format should be:
0,000
or
#,##0

From the AwareIM User Guide:
For example, the pattern string for U.S. currency values is:
$#,##0.00;($#,##0.00)
This indicates that a $ character is prepended to all formatted values. The grouping
separator character , is inserted every three digits
. Exactly two digits after the decimal
place are always shown. Negative values are shown in parentheses. Thus, the value -
1234.56 produces output like:
Bob
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Number format in Document - Report

Post by ACDC »

A numeric attribute has a format defined as 0,0 so that there is a thousands separator (12,557). When attribute is used in a tag for a document report inside a table, it places the comma separator after each numeral in the number (1,2,5,5,7).
Formatting numbers in the report writer
example:

<<Object.Number,#0.0>>
KnightWare
Posts: 139
Joined: Sat Feb 10, 2018 12:56 am

Re: Number format in Document - Report

Post by KnightWare »

Did the trick gents - Thanks.
cishpix
Posts: 183
Joined: Fri Nov 06, 2015 5:07 am
Location: Indonesia

Re: Number format in Document - Report

Post by cishpix »

ACDC wrote:Formatting numbers in the report writer
example:

<<Object.Number,#0.0>>
Hi, I try it in report with LIST command and it doesn't work.

<<LIST(Report.om_Charge, ' ', 'Item', 'Currency', 'Amount,#0.00')>>

or...

<<LIST(Report.om_Charge, ' ', 'Item', 'Currency', 'Amount,#.00')>>


all the both command in the above just print 1 decimal (if it has). Any idea?
Thanks
Regards,

Suwandy
-----------------
Kisaran - Indonesia
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Number format in Document - Report

Post by ACDC »

Why would you use LIST in the report writer ?
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Number format in Document - Report

Post by customaware »

That was a feature added a while ago so that you can display a Grid in a Report without needing to embed a subreport
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Post Reply