Defining the dataset
The dataset is defined on the 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:
- Field in a table
- Variable
- Expression
- 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 the data items to establish a hierarchy of data items and control how the information is gathered.
For example, to create a report that displays a list of customers and lists the sales orders that were placed by each customer, you must define the following data items:
- A data item that corresponds to the
Customertable - A data item...
