Sort on Sub-total, ARGH!

[hughed00]

I have a report that has 3 groups and 4 fields. The one field not grouped is "message size" so that I can sub-total message volume against the other 3 groups which are "site", "transaction", and "destination site".

I managed to get the report to sort using Report-->TopN on the subtotal for message size (I get a list of sending sites sorted by volume of messages/transactions), but can't seem to figure out any way to get a sort on the sub-total for "transactions" which I setup right next to the sub-totals for volume (message size).

Any ideas what I am doing wrong here?

 

[kenhamady]

Can't you pick a second subtotal as a secondary sort in the TopN window? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[hughed00]

I got it working, I was picking the wrong tab for the sort, duh. Thanks.