Introducing SQL Anywhere Studio
  Tutorial: Creating Reports with InfoMaker
    Lesson 3: Enhance your report

Define sorting and grouping

In this section you group contacts by title. To do this, you sort the data by title and then specify grouping by title.

To group contacts

1. Define the sorting. Ascending order is the default.

   • From the Rows menu, choose Sort.

     The Specify Sort Columns dialog appears.

   • Drag tile from Source Data box to the Columns box.

   • Drag last_name and first_name into the Columns box.

   • Click OK.

2. Define the grouping based on the title column, so that all contacts with the same title are grouped together:

   • From the Rows menu, choose Create Group.

     The Specify Group Columns dialog appears.

   • Drag title to the Columns box and click OK.

The grouping is completed. Expand the Preview pane in the same way you did earlier in this lesson, and you will see that the data is sorted. The grouping does not yet appear.