How to: Add a Static Column or Row to a Matrix (Report Designer)

To add a static column or row to a matrix

In Layout view, right-click the data, or detail, cell of the matrix, and then click Add Column or Add Row. Alternatively, drag a field from the Datasets window onto a populated data cell.

Note

If the Datasets window does not appear, in the View menu, click Datasets.
Repeat step 1 to add multiple static columns or rows to a matrix.

The cell splits to create another static column or row. If you add a column or row by dragging a field, Report Designer displays a dark line on one side of the cell, indicating where the field will be positioned when it is dropped onto the matrix.

Note

When a matrix contains a single static column or row, the cell has no column or row header. When multiple static columns or rows are added to a matrix, a static header is created for each static column or row.