Sorting Records

In the first chapter, you learned how to write simple report requests that print, add up, or count records from your data source. You can add detail to a report by sorting the records retrieved using the data from another field, called a sort field.

Sorting reorganizes the records in a report in the order of the values found in the sort field. For example, you can put names into alphabetic order or add up salaries by department.