In a non-production environment; -
SomeFieldsAndLiterals||Cast(Cast(10.2 as double) as char(20))||SomeMoreFieldsAndLiterals
Gives; -
SomeFieldsAndLiterals00000000000000010.20SomeMoreFieldsAndLiterals
(which is the desired effect - 2 decimal places)
In Prod
SomeFieldsAndLiterals000000000000000010.2SomeMoreFieldsAndLiterals
Note the 10.2 is really coming from a measure field.
Note also I cannot see any differences in the config.xml and I have tried to apply a format for the measure in question but it does not make any difference.
Note also, most bizarrely, that the 2 dp seems to work in production, until the report is displayed in the dashboard page....
Any thoughts please?
thanks,
Robert.
