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.
In Layout view, click the table so that column and row handles appear above and next to the table.
Right-click the corner handle of the table, and then click Properties.
On the Groups tab, select the group to edit, and then click Edit.
On the Sorting tab, type or select the expressions by which to sort the data and the sort direction for each expression.