Grouping and Sorting Properties (General Tab, Report Designer)

Use the General tab of the Grouping and Sorting Properties dialog box to define general options for the group. The options displayed on this dialog box vary depending by type of data region and group.

The following table describes the other tabs in the Grouping and Sorting Properties dialog box.

Topic Description

Grouping and Sorting Properties (Filters Tab, Report Designer)

Describes the Filters tab of the Grouping and Sorting Properties dialog box.

Grouping and Sorting Properties (Sorting Tab, Report Designer)

Describes the Sorting tab of the Grouping and Sorting Properties dialog box.

Grouping and Sorting Properties (Visibility Tab, Report Designer)

Describes the Visibility tab of the Grouping and Sorting Properties dialog box.

Grouping and Sorting Properties (Data Output Tab, Report Designer)

Describes the Data Output tab of the Grouping and Sorting Properties dialog box.

Options

  • Name
    Type a name for the group. The name must be unique within the report.
  • Group on
    Type the expressions on which to group the data.
  • Document map label
    Type or select a label or an expression that evaluates to a label. Click the expression (fx) button to edit the expression. The value of the label appears on the document map. Applies only to table, matrix, and list.
  • Label
    Type or select a label or an expression that evaluates to a label. Click the expression (fx) button to edit the expression. The value of the label appears as a label on the chart. Applies only to chart.
  • Parent group
    Type or select a parent group or an expression that evaluates to a parent group. Click the expression (fx) button to edit the expression. Parent groups are used for recursive hierarchies. For more information, see Grouping Data in a Report.
  • Page break at start
    Choose this option to place a page break at the beginning of each instance of this group.
  • Page break at end
    Choose this option to place a page break at the end of each instance of this group.
  • Include group header
    Choose this option to include a group header with the group. Applies only to tables.
  • Repeat group header
    Choose this option to repeat the group header on each page on which the table appears. Applies only to tables.
  • Include group footer
    Choose this option to include a group footer with the group. Applies only to tables.
  • Repeat group footer
    Choose this option to repeat the group footer on each page on which the table appears. Applies only to tables.

See Also

Reference

Report Designer F1 Help
Grouping and Sorting Properties (Data Output Tab, Report Designer)
Grouping and Sorting Properties (Filters Tab, Report Designer)
Grouping and Sorting Properties (Sorting Tab, Report Designer)
Grouping and Sorting Properties (Visibility Tab, Report Designer)

Other Resources

Grouping Data in a Report
Sorting Data in a Report

Help and Information

Getting SQL Server 2005 Assistance