Export (0) Print
Expand All

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.

  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.

    ms170712.note(en-US,SQL.90).gifNote:
    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

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.

Community Additions

ADD
Show:
© 2014 Microsoft