DevExpress decimal separator remains American

Anyone have a solution for this?🤓

At the moment DevExpress reports in Indicium use the format from the system.

So, in your case, you configured it to use C2. Which means to use the currency format with 2 decimals.

While it looks like you configured it for “Dutch” in the previewer - it is showing the euro symbol because your regional settings on your computer are configured as Dutch.

Your server is probably configured to use a different regional setting, and that is why it is showing with the dollar sign.

Changing the currency format based on the locale of the user is also a bit dangerous. A report opened by a dutch user would show €100 - and the same report opened by a user with an English locale would show $100 which is not the same.

If you want it to always use the euro symbol, the following expression might work for you. Is that a solution for you?

'€ ' + FormatString('{0:N2}', ?parameter1)
 

Thank you for your reply, Dick. It almost works. However, I'm still getting a dot as the decimal separator instead of a comma.

Hi ​@Geurt,

I see that the last reaction was 2 weeks ago, do you still require assistance?

​@Jeroen van den Belt Yes, please, I still have dots as decimal in the amounts.

Geurt wrote:

 I have set in DevExpress that the amounts use a Dutch format, I also see this when I do a preview in DevExpress, but when I upload the report in the SF and generate a preview via the application, it uses the American format by default.

 

DevExpress preview:
 

 

Universal preview:

 

I more and more tend to use TSQL to format this stuff and use registered languages for objects to steer formatting, like format([value_column],'C’,'nl’)  or format([value_column],'C’,'pt-BR’) by doing it at server level and returning it in a view or function I also get consistency. In case of cross currency you should remove the C and replace with N for example.