Design the Matrix (Report Wizard)

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

Options

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

See Also

Reference

Report Wizard Help (Report Designer)

Other Resources

Creating a Report Using Report Wizard
Working with Matrix Data Regions

Help and Information

Getting SQL Server 2005 Assistance