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

To add sorting to a matrix

1. In Layout view, click the matrix so that the column and row handles appear above and to the side of the matrix.

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.

See Also

Concepts

Working with Matrix 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