Collapse

How to use Matrix item instead of using the Classic Syncfusion® Report Platform PivotGrid item

The Bold Reports® Standalone Report Designer replaces the classic Syncfusion® Report Platform PivotGrid report item with the Matrix report item. The Matrix report item adds the following features:

  1. Row and column grouping
  2. Total support for row and column groups
  3. Filter and sort expressions support for groups
  4. Cell customization support
  5. Cell merging support
  6. Support to insert other ReportItems
  7. Visual clues to indicate row and column groups

How is the Matrix item different from the classic PivotGrid item?

In the Bold Reports® Standalone Report Designer, the Matrix item assigns fields to each cell with the Matrix Data Assign menu, adds columns from its context menu, and lets you edit every header cell. The classic PivotGrid item used a data assign panel and a default header.

Data assign

PivotGrid ReportItem

The PivotGrid ReportItem uses the data assign panel, by which the fields need to be added as shown in the following image.

PivotGrid Data Assign

Matrix ReportItem

The Matrix ReportItem is provided with the Matrix Data Assign menu, which helps to assign the fields to the particular cell more precisely.

Matrix Data Assign

Adding a column

PivotGrid ReportItem

By dragging the dataset fields in the data assign panel, new columns will be added in the PivotGrid ReportItem as shown in the following image.

PivotGrid Column

Matrix ReportItem

Multiple columns can be added in the Matrix dynamically using the Matrix Context menu as shown in the following image.

Matrix Column

PivotGrid ReportItem

The PivotGrid ReportItem will be added with default header when dataset fields are assigned, which can be modified with the properties provided in the property panel.

PivotGrid Header

Matrix ReportItem

The Matrix ReportItem considers each cell as an individual and has the option to provide static values wherever required using the Multi-Text Run Editor dialog.

Matrix Header