Dynamics AX 2012
A segment of our target customer base requires numeric characters to be rendered in reports using the national format to be compliant with government standards for the Department of Zakat and Income Tax documentation. Developers also require field level control over the reporting framework’s numeric transformations which affect column alignment and formatting. This document captures the reporting framework’s solution for using AX Metadata to control International adaptations for RTL languages (i.e. Arabic & Hebrew). It also contains instructions for using Precision Design properties to control the framework’s textbox transformations.
The reporting framework provides automatic runtime design adaptations using Report Design Customization Extensions (RDCE) based on the language selected in report viewer’s AX client configuration settings. RDCE will automatically apply the numeric transformations for RTL languages when appropriate. There are two types of transformations applied by the framework for numeric characters:
Note: EDT properties are only available using the AX Metadata service in cases where a direct field reference is defined in the text box expression.
The following example of an AX production report illustrates the transformation actions performed by the RDCE process. The layout of the design is flipped along the Y-axis. In addition, the framework leverages the AX Meta data service to determine when to adjust column alignments.
Sample production report – LTR language (EN-US)
Same report after RDCE transformations – RTL language (Arabic)
The table below outlines the default behavior applied by the reporting framework during the RDCE transformation for RTL languages.
This section describes the development process for controlling the RDCE transformations using text box properties in the Visual Studio Precision Designer.
Use the following steps to prevent the RDCE engine from flipping the text box alignment when the report is rendered in RTL languages.
Identify and select the Text box in the Precision Design where you’d like to override the formatting transformations applied by RDCE.
In the Properties Window, click the button rendered in the “CustomProperties” edit box.
Add or Update the value associated with the “AXDataType” to use the value “Integer” or “Float”
Save your modifications to the Custom Properties and the report design
Rebuild and Deploy the report
Use the following steps to control the variation of the number format to use. This step will instruct the SSRS framework to render numerals using the National format.
In the Properties Window, set the value associated with the “NumeralVariant” property to “3”.
Recommendation: The NumeralVariant property must be managed using an expression to ensure that the value is set to “3” only in cases where the report is being rendered in Arabic.
Yes, you can completely disable the RTL transformation in an Auto Design. However, Custom Properties used to over-ride numeric transformations are only accessible in the Precision Designer.
Yes, the text box Custom Properties are accessible in all areas of the report design
No, the SSRS framework does not support rendering dates using the national format
It does NOT affect anything besides the text box RTL transformations
Integer, String, Float, Boolean, DateTime
Integer or Float
No errors are surfaced, since the framework only looks for these two values -> Float, Integer. Everything else is ignored.