How to: Sort Data in a Table (Report Designer)

You can use expressions to provide a table data region with presorted data. To find out how to enable end-user sorting in a table, see Sorting Data in a Report.

To add sorting to a group in a table

  1. In Layout view, click the table so that column and row handles appear above and next to the table.

  2. Right-click the corner handle of the table, and then click Properties.

  3. On the Groups tab, select the group to edit, and then click Edit.

  4. On the Sorting tab, type or select the expressions by which to sort the data and the sort direction for each expression.

To add sorting to table details

  1. In Layout view, click the table so that column and row handles appear above and next to the table.

  2. Right-click the corner handle, and then click Properties.

  3. On the Sorting tab, type or select the expressions by which to sort the data and the sort direction for each expression.

See Also

Concepts

Working with Table Data Regions
Grouping Data in a Report
Report Designer How-to Topics

Other Resources

Report Designer F1 Help

Help and Information

Getting SQL Server 2005 Assistance