Design the Table (Report Wizard)

 

Applies To: SQL Server 2016

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

Options

Available fields
Choose fields to appear on the page above the table, in a table grouping, or in table details. To move a field from Available fields to Page, Group, or Details, select the field and then click Page, Group, or Details. 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.

Group
View the list of fields by which to group the data in the table. 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 table. To change the order of the fields, select a field, and then click the up button or the down button.

See Also

Tables (Report Builder and SSRS)
Report Wizard Help