Sort one field before a group Crystal 8.5

[mdieckman]

This may be very simple, but I don't know if it can be done.

Lets say that I am grouping on an ID number so Crystal wants to sort that first in ascending order and then I also have a date that I want to sort.

I would like to sort the date first as the ID number isn't always in the order that it was paid. Is there any way to do this other than changing what I am grouping on?

Example of how it is sorting:

ID # Paid date --- these are in the Group header
10001 01/02/2007
detail lines underneath here
10002 12/31/2006
detail lines underneath here
10003 01/03/2007
detail lines underneath here

Example of how I want it to sort:

ID # Paid date --- these are in the Group header
10002 12/31/2006
detail lines underneath here
10001 01/02/2007
detail lines underneath here
10003 01/03/2007
detail lines underneath here

Thanks in advance.

 

[mdieckman]

Nevermind...I created a changed my first group to the date and then created a second group for the ID and it sorts like that.