Thousands Separator in Reports

<<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+

Have you tried <<Object.Number,'#,##0.00'>> ?

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????

Whoops!.... Try this....

<<Costings.Style.SPQuantity*Costings.Style.SPinGBP@'#,##0.00'>>

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