Defining Multiple Report Layouts
In AL you have the option of defining multiple layouts for one report in code. This means that you can offer multiple versions of a layout for different purposes. Defining multiple layouts applies to both report objects, and report extension objects. The layouts can be of different types, meaning that you can have, for example, a Word layout and an Excel layout for one report, or multiple Excel layouts for one report. This enables creating report extensions that only add layouts to an existing report and packaging it as an extension .al file.
Read more about enabling multiple report layouts and implementing rendering differentiation in extensions, see Enabling the Microsoft Word rendering engine.
Enabling multiple layouts
To enable multiple layouts, you must use the
rendering section of a report object. Inside the
rendering section, you define one or more
layout sections. In each of the
layout sections, you specify details about the layout file path and name, you provide a Caption Property and a Summary Property which will be displayed to the user in the Report Layouts page in Business Central.
The default layout can be specified with the DefaultRenderingLayout Property report property. This property cannot be set on report extension objects, only on report objects.
If you do not specify a caption, the layout name will be displayed to the user.
If the extension is translated, the
Summary properties are included in the .xliff file and translated as well. For more information, see Working with Translation Files.
Reports using the previous property-based layout specification can be converted to use the
rendering section by using a code action. To use this, ensure code that actions are switched on in your AL extension settings and place the cursor on any of the old layout properties to use the action. Layouts of type RDLC, Word, Excel, and Custom can be specified with the new rendering syntax. For more information, see AL Language Extension Configuration.
Layout definition in AL
The following example illustrates how the
EmpReportExt report extends the
"Employee - List" list by adding four report layouts as options for printing this report. The report extension only adds the layouts, the dataset remains the same as the existing Employee List report.
reportextension 50102 EmpReportExt extends "Employee - List"
Type = Excel;
Caption = 'ExcelPivot';
Summary = 'Employee list shown in Pivot table in Excel';
LayoutFile = 'EmpShownAsPivot.xlsx';
Type = Excel;
Caption = 'ExcelColumns';
Summary = 'Employee list sorted by last name in Excel';
LayoutFile = 'EmpSortedByLastName.xlsx';
Type = Word;
Caption = 'WordList';
Summary = 'Employee list sorted by last name in Word';
LayoutFile = 'EmpSortedByLastName.docx';
If one or more of the layouts do not exist, they will be generated when selecting Ctrl+Shift+P, and then choosing AL: Package. The layouts will appear in your project in the right pane of Visual Studio Code. The generated reports contain the dataset from the report, and you can modify and model the reports in each of the layout types as you want.
Creating layouts in Excel, RDL, or Word is further described in the topics shown under See also.