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([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.
Hi @Geurt, does the solution offered by Freddy work out for you?