This documentation is archived and is not being maintained.

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

  1. 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.

    ms159652.note(en-US,SQL.90).gifNote:
    If the Datasets window does not appear, in the View menu, click Datasets.

  2. 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.

    ms159652.note(en-US,SQL.90).gifNote:
    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.

Show: