### Sorting and grouping information

You can group either by sorting data, so that records with like data appear grouped in the sorted list, or by summarizing data with aggregate functions, so that summary data appears in your query for each group of records.

1. From the Database Fields area, select the field you want to sort.
2. Click Add.

   The field is added to the Group Fields area.

3. From the Order drop-down list, choose the order in which you want the data sorted.
   - In ascending order: A-Z.
   - In descending order: Z-A.
   - In original order: the order that Seagate Crystal Reports receives the records. In most cases this is the order of the data from your database.

4. Repeat these steps for each field as required.
5. Click Next.

   The Select tab appears.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com