Number format in Document - Report
-
- Posts: 139
- Joined: Sat Feb 10, 2018 12:56 am
Number format in Document - Report
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).
Re: Number format in Document - Report
The format should be:
0,000
or
#,##0
From the AwareIM User Guide:
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
Re: Number format in Document - Report
Formatting numbers in the report writerA 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).
example:
<<Object.Number,#0.0>>
-
- Posts: 139
- Joined: Sat Feb 10, 2018 12:56 am
Re: Number format in Document - Report
Did the trick gents - Thanks.
Re: Number format in Document - Report
Hi, I try it in report with LIST command and it doesn't work.ACDC wrote:Formatting numbers in the report writer
example:
<<Object.Number,#0.0>>
<<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
Suwandy
-----------------
Kisaran - Indonesia
Re: Number format in Document - Report
Why would you use LIST in the report writer ?
-
- Posts: 2400
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Number format in Document - Report
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....