<<Object.Number,#,##0.00>> gives 'Syntax Error at Token ',' (Column x)
works fine without the thousands separator.
tried /, and \, and '#,##0.00' and even #+##0.00 - that was interesting it produced 1234.56+
Thousands Separator in Reports
Thousands Separator in Reports
Colin
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
-
- Posts: 2410
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Thousands Separator in Reports
Have you tried <<Object.Number,'#,##0.00'>> ?
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....
Re: Thousands Separator in Reports
sure have
<<Costings.Style.SPQuantity*Costings.Style.SPinGBP,'#,##0.00'>>
see error attached
is it because it is a calculation???
Yes! it is.
<<Costings.Style.SPQuantity,'#,##0.00'>> works fine, but even enclosing the calculation in () doesn't resolve the error.
Woe is me! Do I really have to put this figure in the database????
<<Costings.Style.SPQuantity*Costings.Style.SPinGBP,'#,##0.00'>>
see error attached
is it because it is a calculation???
Yes! it is.
<<Costings.Style.SPQuantity,'#,##0.00'>> works fine, but even enclosing the calculation in () doesn't resolve the error.
Woe is me! Do I really have to put this figure in the database????
- Attachments
-
- Capture.JPG (13.45 KiB) Viewed 5221 times
Colin
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
-
- Posts: 2410
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Thousands Separator in Reports
Whoops!.... Try this....
<<Costings.Style.SPQuantity*Costings.Style.SPinGBP@'#,##0.00'>>
<<Costings.Style.SPQuantity*Costings.Style.SPinGBP@'#,##0.00'>>
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....
Re: Thousands Separator in Reports
Dear Eagles9999,
Brilliant! Works a treat - I can't thank you enough.
How did you discover this. It makes me feel pretty stupid.
best wishes
Brilliant! Works a treat - I can't thank you enough.
How did you discover this. It makes me feel pretty stupid.
best wishes
Colin
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby