Sorting and Grouping
When you first create and preview a report, the report shows details sections in natural order. That is, the records appear in whatever order the database sends them to Crystal Reports. This order can vary widely, depending on what database you are using, how you link tables, and the actual order in which records were entered into the database.
You’ll probably want to control the order in which information appears on your report. An employee listing, for example, isn’t very useful if it isn’t in alphabetical order. A sales breakdown is probably more helpful if you see your sales figures in a particular order. You’re probably interested in a highest-to-lowest sequence of order quantities if you’re about to send gifts ...

Get Crystal Reports 2008: The Complete Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.