How do I order groups alphabetically?

It may be a bit more complicated then that, but here goes.

This report lists overtime on a weekly ba开发者_如何学JAVAsis. Each driver has worksheets that outline details of a given shift. The user selects a period of a week, and I have some formulas that fill variables with their hours worked for each day of the week. The lines look something like this:

CKL09844 - LATTA   Scott    9.5   8.6    10.5    11     0 hourlysum, etc.

The records are grouped by the 'Driver ID' - the first field - but I'd like to have them listed in alphabetical order. Only the group footers are being displayed currently. Anyone have any advice?

Edit: List them alphabetically by last name, that is.

You can either

1. Change the group to the 'LastName, FirstName' field or fields instead of driverID or

2. Use a summary to sort the group. You can do this by inserting a summary like maximum({table.name},{table.driverID}) and placing it in the footer and then suppressing it (It's stupid but Crystal needs this field actually in the report before it will allow you to access the next step). Then, go to "Report -> Group Sort Expert -> For this group sort: All" and select the summary you just made.