Two sorts in the same group 1

[lkerr]

I want to do two separate sorts on the same group (based on spending and profit). However, CR9 doesn't seem to have any sort of option to do this. What I have set up is this: I have two columns, a listing of clients with their spending and the same clients with their profit. What we want to do is sort those two columns right next to each other so we can see which clients are getting the most profit from their spending. I can't seem to find any way to do this. I can only get one to sort. How can I format this? (I currently have them both located in a group header, due to the way our database is set up.)

 

[synapsevampire]

Those are different data sources, so I think that you'd need to either presort them in a table/view/sp so that they will display in that fashion, or use a subreport or two.

-k