Cast / Format - 2 dp for double?

Robert Angel

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.