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

  1. In the Layout pane, 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.

    Note

    The corner handle is the handle where the column and row handles meet.

  3. On the Sorting tab, for Sort on, select =Fields!OrderDate.Value. This will sort the detail data by order date.

  4. Click OK.

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

Other Resources

Sorting Data in a Report

Help and Information

Getting SQL Server 2005 Assistance