Design the Matrix

 

Applies To: SQL Server 2016

Use this page of the Report Wizard to select fields for the report.

Available fields
Choose fields that appear on the page above the matrix, as a row group, column group, or detail. To move a field from Fields to Page, Columns, Rows, or Details, select the field, and then click the Page, Columns, Rows, or Details buttons. Alternatively, you can drag the field to the appropriate box.

Displayed fields
Displays the fields that have been assigned to the page, group, or details. Click Remove to delete the field from the list.

Page
View the list of fields that appear at the page level. To change the order of the fields, select a field, and then click the up button or the down button.

Columns
View the list of fields that appear as matrix columns. To change the order of the fields, select a field, and then click the up button or the down button.

Rows
View the list of fields that appear as matrix rows. To change the order of the fields, select a field, and then click the up button or the down button.

Details
View the list of fields that appear in the detail section of the matrix. To change the order of the fields, select a field, and then click the up button or the down button.

Report Wizard Help

Community Additions

Show: