I have a report grouped by an Account Number field. I don't want the report sorted by this field though, I want it sorted by the Name. How can I do this? A Name can be assigned to multiple account numbers, so I would like it to look like:

Account: 345
Name: Doe, John
--Details--

Account :346
Name: Doe, John
--Details--

Account: 123
Name: Jane, Mary
--Details--

But instead it gives me

Account: 123
Name: Jane, Mary
--Details--

Account: 345
Name: Doe, John
--Details--

Account :346
Name: Doe, John
--Details--


In the datareports for VB6 I could just select the Account and the Name to group by, resulting in 1 grouping that I could sort by Name, but with CRXI it creates 2 separate groups if I do that..