Report Design Overview

Article
03/31/2022
2 minutes to read

A report is composed of the following items:

A report object
A report dataset
A report layout
A request page
Properties, triggers, and code

You design a report by first defining the dataset, and then designing the visual layout.

Report object

You create a report object in the AL Language development environment to define the data model, or dataset of a report. You can structure and summarize information in a report and print documents, such as sales quotes and invoices. For more information, see Report Object.

Report dataset

In order to define the underlying data model, you use the report dataset. A report dataset determines the data that is extracted or calculated from the Dynamics 365 Business Central database tables that can be used in a report. You build the report dataset by adding data items and columns. For more information, see Report Dataset. You can also extend a dataset from an existing report, to add more columns for example. For more information, see Report Extension Object.

Tip

It is possible to use a query object as the data source for a report. This can in many cases improve the performance of data retrieval when running the report.

Report layouts

The visual layout determines the content and format of a report when it is viewed and printed. You build the layout of a report by arranging data items and columns and specifying the general format, such as text font and size. A report that is viewed, printed, or saved from a Dynamics 365 Business Central client must have a report layout. There are three types of report layouts: layouts using report definition language (RDL), Word report layouts, and Excel report layouts. You can also extend an existing report, for example, to add a new layout. For more information, see Report Extension Object.

Note

The layout in a report extension will not automatically be used when the report extension is deployed. To use the report extension layout, in Business Central, go to the Report Layout Selection page to choose to use the new layout for the report in question by choosing it from the Custom Layout Description drop-down box.

RDL layout

To create an RDL layout report, you use Visual Studio Report Designer or Microsoft SQL Server Reporting Services Report Builder. For more information, see Creating an RDL Layout Report.

Important

RDL layouts can result in slower performance with document reports, regarding actions that are related to the user interface (for example. like sending emails) compared to Word layouts. When developing layouts for document reports, we recommend that you design Word layouts instead of RDL. With Word layouts, reports are not impacted by the security constraints on sandbox app domains like they are with RDL layouts. From a service perspective, RDL layouts are not trusted, so they will run in a sandbox app domain that only lives for the current report invocation.

Word report layout

You create Word layouts by using a Word Document. Word layouts are based on a Word document that includes a custom XML parts that represents the report dataset. For more information, see Creating a Word Layout Report.

Excel report layout

Excel report layouts are based on an Excel (.xlsx) document and can take advantage of the capabilities in Excel such as sliders, diagrams, charts, pivot tables, and PowerQuery to design the report. For more information, see Creating an Excel Layout Report.