The Infolog

A blog of Dynamics AX development tips and tricks

Skip to: Content | Sidebar | Footer

Formatting on fields within SSRS

29 September, 2013 (01:18) | Uncategorized | By: Howard Webb

SSRS pulls the formatting direct from the field’s EDT in AX, however this only works if the field is on the report table and is not a aggregate function. As such it does not really work for values that will be used in a header or footer section. There are plenty of examples of this causing issues in standard reports, for example the invoice date on a sales invoice (which is displayed as a UTC not a date),  and as such it is not really a valid way to output to the user. While you can apply formatting within the SSRS report, it will only apply the date format on the SSRS server. To avoid this issue I have started to use a string rather than the source field’s EDT. You can then use strfmt or one of the other type2str methods in system to make sure you get a correct value that matches the EDT and also the regional settings for the user.

Print Friendly, PDF & Email