Skip to content

Dataset Analysis

On the Report Layouts and Document Creator User-Defined Report Layouts pages a Dataset action group is available that contains a set of useful actions that can be used to analyze which columns are used and unused by layouts in the environment.

Report Layouts - Dataset Actions

View Columns Action

The View Columns action can be used to view the columns of a report object and whether the selected layout uses its columns.

View Columns Action

Report Columns Usage Overview

On the page that opens when invoking the action, the following fields are available:

  • Data Item Name

    Specifies the name of the (parent) data item that a column belongs to.

  • Data Item Table Caption

    Specifies the caption of the (parent) data item's table.

  • Column Name

    Specifies the (unique) name of the column.

  • Custom

    Specifies if the column (or data item) is added via a Dataset Extension.

  • Used by Any Report Layout

    Specifies whether the column is used by any Document Creator report layout that exists for the report object.

  • Used by Selected Report Layout

    Specifies whether the column is used by the selected Document Creator report layout.

  • Used by Filter Set Filters

    Specifies whether the column is used by any filter set filters for dataset extensions for the report object.

    It is possible to drill-down on this field to view the filter sets in which the column is referenced in the corresponding filters.

Additionally, the Column Name will displayed in Red if it concerns a report column that is not used by any report layout (nor by any filters for custom columns) in the current Business Central environment.

Also, if it concerns a Custom Column then it will be displayed in Bold + Red if it concerns a custom column that is not used by any report layout (nor by any filters for other custom columns) in the current Business Central environment. These are columns that are likely candidates to be removed from the report object.

Report Columns Usage Overview - Unused Custom Columns

View Data Items Action

The View Data Items action can be used to view the data items of a report object.

View Data Items Action

View Data Items Example

On the page that opens when invoking the action, the following fields are available:

  • Data Item Name

    Specifies the name of the data item.

  • Data Item Table Caption

    Specifies the caption of the data item's table.

  • Custom

    Specifies if the data item is added via a Dataset Extension.

Export Original Dataset Action

The Export Original Dataset action opens the report request page of the report object (of the selected layout) and exports the original dataset generated by Business Central (N.B. without any Dataset Extensions or other transformations applied to it).

Export Original Dataset Action

Export Customized Dataset Action

The Export Customized Dataset Action opens the report request page of the report object (of the selected layout) and exports the dataset with dataset extensions/transformations applied.

Export Customized Dataset Action

Export Compressed Dataset Action

The Export Compressed Dataset action opens the report request page of the report object (of the selected layout) and exports a compressed version of the dataset with all unused columns removed.

Export Compressed Dataset Action


Last update: June 30, 2025