Number format in Document - Report

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

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:

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

Did the trick gents - Thanks.

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

ACDC

Why would you use LIST in the report writer ?

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