If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#50996 by KnightWare
Wed Jun 05, 2019 8:38 pm
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).
#50999 by BobK
Thu Jun 06, 2019 12:10 pm
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:
#51016 by ACDC
Fri Jun 07, 2019 7:21 pm
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>>
#51270 by cishpix
Wed Jul 31, 2019 3:52 pm
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
#51272 by eagles9999
Thu Aug 01, 2019 12:38 am
That was a feature added a while ago so that you can display a Grid in a Report without needing to embed a subreport

Who is online

Users browsing this forum: No registered users and 16 guests