Currency formatting

[Chipo]

Hi,

I have several tenants with different currency preferences.
How I can set up some preferences for report viewer on runtime to use them for currency formatting without amending the report "text format" properties?

Have a great day.

[HighAley]

Hello.

You can create a variable where you can set the currency symbol and use one of next expression:

Code: Select all

{DataSource.CurrencyColumn.ToString("N2") + " " + VarCurrency}
{VarCurrency + DataSource.CurrencyColumn.ToString("N2")}

The Text format property should be set to General.

Thank you.

[Chipo]

Hi,

Can I use "Use Local Settings" by chance. I know current user preferences at runtime and can (possibly) "fix" local settings for report.
Is it possible?

Thank you.

[HighAley]

Hello.

Can I use "Use Local Settings" by chance. I know current user preferences at runtime and can (possibly) "fix" local settings for report.
Is it possible?

Unfortunately, this Settings doesn't work in the Flash Designer, because Flash player have no access to the local settings.

Thank you.