Lesson 4: Sorting the Detail Data
Add sorting to the detail data in the table to sort data within each group. The sort order is used to list each sale by order date for each sales person.
To sort detail data in a report
In the Layout pane, click the table so that column and row handles appear above and next to the table.
Right-click the corner handle and then click Properties.
Note
The corner handle is the handle where the column and row handles meet.
On the Sorting tab, for Sort on, select =Fields!OrderDate.Value. This will sort the detail data by order date.
Click OK.
.gif "Sorting tab, Table Properties page")
Next Steps
You have successfully added an expression that sorts sales data for each sales person. Next, you will add a subtotal to calculate and display the dollar sales for each sales person. See Lesson 5: Adding a Subtotal.
See Also
Concepts
Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report