You can add fixed rows and columns to provide space for additional detail data or labels.
To automatically add static columns and rows to a matrix
- In the Layout view of the report, drag a field from the Data Explorer onto the bottom right (detail) cell in the matrix.
- Drag an additional field onto the detail cell to split the cell and create an additional static column or row. (A grey bar indicates where the field will be dropped.) This creates a static cell on the selected side of the original detail cell, and adds a label using the field name.
Dropping an additional field.
New static column.
The label is added in the position indicated in the following table, depending on the side of the original detail cell on which the static column or row is placed.
| Position Relative to Detail | Position of Label | Description |
|---|---|---|
| Above | Left | Static row that appears above the detail. The row header (bottom left cell) spans both rows. An empty label cell is added so that you can label the details. |
| Below | Left | Static row that appears below the detail. The row header (bottom left cell) spans both rows. An empty label cell is added so that you can label the details. |
| Left | Above | Static column that appears to the left of the detail. The column header (top right cell) spans both columns. An empty label cell is added so that you can label the details. |
| Right | Above | Static column that appears to the right of the detail. The column header (top right cell) spans both columns. An empty label cell is added so that you can label the details. |
To manually add static columns and rows to a matrix
- In the Layout view of the report, right-click the bottom right (detail) cell and select Add Column or Add Row.
- Cells are added to the table as indicated in the following table. You can add text or expressions to the cells as needed.
| Selection | Position Relative to Detail | Position of Label | Description |
|---|---|---|---|
| Add Row | Below | Left | Static row that appears below the detail. The row header (bottom left cell) spans both rows. An empty label cell is added so that you can label the details. |
| Add Column | Right | Above | Static row that appears below the detail. The row header (bottom left cell) spans both rows. An empty label cell is added so that you can label the details. |