Output processing sort ?

[jimm]

Does anyone know how to make a second pass in output processing to resort the output by a subtotal field.  The first pass would actually determine the totals that would be used for the resort. Example: Have product groups A,B,C, etc each product has type 1,2,3. I need to print a detail report that will order the product types by total sold within each product group for each customer. Could have thousands of customers and/or products so I don't think temp arrays are a viable option. I tried using the SORTn command but since the subtotal figure I need to sort by isn't calculated until the output processing I could not get it to work. Any suggestions would be greatly appreciated. Thank you!

[kenbrody]

As you said, the subtotals aren't known until you completely finish the output phase.  There is no way to automatically make another pass to resort and then re-output the report.

You can, however, manually make two passes.  The first pass will save the subtotals in another file.  Then, use the SORTn command in processing when you run the second pass, looking up the previously-calculated subtotals.