Hi,
I'm currently using Report Designer 8 and i would like to know how to format my number field using EU standard (right now is using a US format).
To be clear, i would like to go from this:
to this:
I already tried modifying the number field format by hand, resulting in an empty cell while printing the report.
The SQL field printed is a FLOAT.
I would try using a formula for the formatting. The conversions are done during rendering. If your formula can use clever logic to detect currency formatting desired, then you just submit the formatting code given the one you want.
I second the usage of a formula for this. Is the report based on locale? Also note the browser will push a locale to the report so depending on what that value is you should be able to use an IF on the formula