+5I 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:
Best answer by Freddy
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.
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)
+5Thank you for your reply, Dick. It almost works. However, I'm still getting a dot as the decimal separator instead of a comma.
+16I 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
