I have a crystal report that contains customer information. For each customer, there is a subreport that contains a cross tab listing the customer's invoice amount for each month and a total invoice amount (sum field) as the rightmost column.
I would like for my main report to sort the customers by the total invoice amount. But since this value is contained in the cross tab of the subreport, I'm not sure I can access it. Any ideas on how I might be able to do this, or the best way to do this?