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:
Page 1 / 1
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.
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(ovalue_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.