How to use Matrix item instead of using the Classic Syncfusion Report Platform PivotGrid item?
Replaced the Syncfusion Report Platform PivotGrid ReportItem with our brand new Matrix ReportItem in our Bold Report Designer. The Matrix ReportItem has additional unique features as follows:
- Row and column grouping
- Total support for row and column groups
- Filter and sort expressions support for groups
- Cell customization support
- Cell merging support
- Support to insert other ReportItems
- Visual clues to indicate row and column groups
Alternative action in Matrix ReportItem instead of PivotGrid ReportItem
The PivotGrid ReportItem uses the data assign panel, by which the fields need to be added as shown in the following image.
The Matrix ReportItem is provided with the Matrix Data Assign menu, which helps to assign the fields to the particular cell more precisely.
Adding a column
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.
Multiple columns can be added in the Matrix dynamically using the Matrix Context menu as shown in the following image.
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.
The Matrix ReportItem considers each cell as an individual and has the option to provide static values wherever required using the
Add Text feature present in Matrix Data Assign menu.
If you need to create a header row in Matrix ReportItem, then you need to provide the static text values as mentioned above and click the whole row to modify it using the properties provided in the property panel.