Hello Dale,

1) If you need to have different currencies in one project you can define own pattern for the field or summary control.

Just select Number value for property Kind and input a format, like here:
₱#,##0.##

It will produce values like
2,222.99

The format can be quite complex, it is implemented by the ICU library.

Here is the documentation for formatting in reports.

2) Or if you just want to print one currency instead of another in entire project - it is controlled by Locale setting on the project tab.

Thank you for the response, Sergey. However, I am dealing with international transactions where the currency is changed as per transaction. The currency symbol is stored in the database. Can I generate the format at run-time? Something like, ThisObject.Format = Table.FieldCurrency + "###,###,##0.00"? There's a Pre-Place script but I don't know how to make use of it.

Hi Dale,

pre_build script of the report is better for this task - it is executed just once.

For example, currency symbol may be passed as the parameter:
report.controls.field1.pattern = report.parameterValue( "currencySumbol" ) + ",##0.##";

Sergey, your guidance solves my problem. Thank you very much!

Cheers!