Hi Expert,

I have a question about Crystal reports. I know there are lots of veterans here. In my Crystal reports, it is grouped by three fields. I want the report sorted by another field instead of group fields.

The report is as following:
Category#----Brand-----------SKU#------------Sales$
7---------------NatPath---------55702-----------60.00
7---------------NatPath---------55700-----------20.00
7---------------NatPath--------subtotal--------80.00
7---------------Glut-------------55605-----------30.00
7---------------Glut-------------55610-----------20.00
7---------------Glut-------------55609-----------10.00
7---------------Glut------------subtotal--------60.00
7---------------Foods-----------55545-----------30.00
7---------------Foods-----------55541-----------10.00
7---------------Foods----------subtotal--------40.00
7---------------Subtotal-------------------------180.00
8---------------Delicious-------55299-----------20.00
8---------------Delicious-------55242-----------10.00
8---------------Delicious------subtotal--------30.00
8---------------Bliss------------53036-----------20.00
8---------------Bliss-----------subtotal--------20.00
8---------------Purely----------55216-----------10.00
8---------------Purely---------subtotal--------10.00
8---------------Subtotal-------------------------60.00

The group fields are:
Category#
--------Brand
----------------SKU#

I want the report sorted by field Sales$ in Descending order.
ie.
Inside each group Brand, the records are sorted by field Sales$ in descending order.
Inside each group Category#, the groups Brand should be sorted by field Sales$ (subtotal number)
Groups Category# can be sorted by itself in ascending order.

Any help will be appreciated!

Bruce Ma