On Classic report layouts that use an option variable, you can use the option string of the option variable to determine which option was selected by the end user. In a client report definition (RDLC) report layout, an option variable is handled as a normal string, not an option string. If you have a multilanguage application, handling the option as a normal string will cause problems in the displayed report. You must manually convert the option string to an integer variable and then use the integer variable in the RDLC report layout.
Before you begin this procedure, you must create a layout suggestion for the report. For more information, see How to: Create a Layout Suggestion.
To assign the option string to an integer variable
-
In the Classic client, on the Tools menu, click Object Designer.
-
In Object Designer, click Report, select the report that you want to modify, and then click Design.
-
On the View menu, click C/AL Globals.
-
In the C/AL Globals window, on the Variables tab, add the following variable.
Name DataType ShowTypeNo
Integer
-
Close the C/AL Globals window to save your changes.
-
On the View menu, select C/AL Code.
-
In the C/AL Editor, add the following code to the OnAfterGetRecord trigger to assign the option string to an integer value.
Copy CodeIF ISSERVICETIER THEN BEGIN ShowTypeNo := ShowType; END;
-
On the View menu, click Sections.
-
Add a hidden text box with ShowTypeNo as the value of the SourceExpr field. For more information, see How to: Add and Identify Hidden Fields.
-
On the File menu, click Save.
-
In the Save window, select the Compiled check box, and then click OK.
To use the integer variable instead of the option string
-
In the Classic client, on the Tools menu, click Object Designer.
-
In Object Designer, click Report, select the report that you want to modify, and then click Design.
-
On the View menu, click Layout.
-
In Microsoft Visual Studio, in the Report.rdlc file, use the integer variable wherever you used the option string, such as in expressions.