Sorting within Groups

[byrne1]

I am trying to group my customers by how much they have spent in their lifetime. I have successfully set up groups as follows:

I - sales >10000
II - sales 5000-9999.99
III - sales 2000-4999.99
IV - sales <2000

The CUSTOMER table has a CUMSALES field that I am using to group. My problem is that the records in each group are not being sorted. I want them to be sorted in descending order based on CUMSALES.

I am running CR 10.

 

[Madawc]

Try Report > Record Sort Expert. This lets you choose extra fields to sort by, below Group level.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[byrne1]

I originally tried that, but since the CUMSALES field was the group, it would not let you select this field to sort by below the group. I ended up creating a new formula, setting it to equal the value of CUMSALES, and then sorted by that within the CUMSALES group.