Handling language-specific formatting of placeholders

The parameter AX_RenderingCulture is used to handle different language-specific formatting preferences. For example the English for numbering a dot is used and in German a comma.

Possible values are en-us, de-at, ….

The rendering culture can be used to format data fields according to the report language. To do so, it is necessary to include the ReportParameter table in the data map. The best way is to clone one of the data sources, because there is no need to fill out the connection setup again.

Steps

In Microsoft Word or Excel, go to the dox42 ribbon and select Data Map.
dox42 ribbon
The Data Map Designer window opens.
Selected the desired data source.
Select the Clone button.
A copy of the data source is created.
Select the copy and select the Edit button.
In the Name text field enter ReportParameters.
Select the ReportParameter in the Table dropdown.
Select the AX_RenderingCultureParameter checkbox.
AX_RenderingCultureParameter checkbox in data source
Select a placeholder where you want to apply language-specific formatting.
In the dox42 Data Fields pane into the Culture text field enter the following text: EN => <%ReportParameters.AX_RenderingCulture%>
Select the OK button.

Result

The placeholder will be formatted language-specific.

Best practice: Using a dynamic field for language-specific placeholders

It can be useful to create a separate dynamic field for “Culture” in the ReportParameters data source and further use this dynamic field in all other places of a template. Therefore, if you need to make any changes in the format of data fields, you will need to modify only one field.

In Word or Excel, go to the dox42 ribbon and select Data Map.
dox42 ribbon
The Data Map Designer window opens.
Select the Dynamic Field button.
See Creating a dynamic field.
Enter the name of the field.
Into the Visual Basic Code text field enter: result = "EN => " + ReportParameters.AX_RenderingCulture.
Dynamic Field with ReportParameters.AX_RenderingCulture
Select the OK button.
In the document template select a placeholder with the Type Number.
Into the Culture text field insert EN => <%ReportParameters.AX_RenderingCulture%>.
Filled out Culture text field
Select the OK button.