Sorting SubTotals 1

[gsmithmme]

I am using Crystal 8.5 on a Paradox database. I need to create a report that displays customers and the total amount invoiced for each Job, but I need it sorted from highest invoiced amount to smallest amount. Problem is that some jobs have 2 or 3 invoices that sum to give the total amount invoiced, while others may only have 1. I have a group by JOB, which subtotals the invoices, but I cannot sort the subtotals in highest to lowest order. I have tried running totals and subreports with shared currency variables to calculate the subtotal by Job, but I cannot find a way to sort this:

Example;

Group H - J1
Invoice 1 - $100.00
Invoice 2 - $200.00
Group F - J1 Total $300.00

Group H - J2
Invoice 3 - $500.00
Group F - J2 Total $500.00

Group H - J3
Invoice 4 - $200.00
Invoice 5 - $200.00
Group F - J3 Total $400.00


So, the order I need would be J2, J3, J1. I may just be having a bad day, but I am stumped.

 

[lbass]

If you insert a sum on the amount field in the detail section at the Job group level, do you get the correct result for the job? If so, you can just use the sum of the amount field as your group sort field (report->group sort).

-LB

 

[gsmithmme]

Brilliant. As a Newbie, you really saved me (for about the 10th time!) Thanks so much!