Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

Defining the dataset

The dataset is defined on Report Dataset Designer in the Microsoft Dynamics NAV Development Environment. The report dataset is built from data items and columns. A data item is a table. A column can be one of the following:

• A field in a table
• A variable
• An expression
• A text constant

Typically, the data items correspond to the fields in a table. When the report is run, each data item is iterated for all records in the underlying table with an appropriate filter defined.

When a report is based on more than one table, you must set relations between the data items so you can retrieve and organize the data. In Report Dataset Designer, you indent data items to establish a hierarchy of data items and control how the information ...