To make a long story short. We have a table that requires records to be subtotaled and printed twice and in different order on the report using two different sorting criteria to make two different columns. Something like this:


A/C# Description Debit Credit
---- ------------------------------ ---------- ----------
560 Expense - Furniture & Fixtures 26.20
562 Expense - Buildings 1,941.36
564 Expense - Autos 117.14

160 Acc/Depr - Furniture & Fixtures 26.20
162 Acc/Depr - Buildings 1,941.36
164 Acc/Depr - Autos 117.14

--------- -----------
2,084.70 2,084.70

We are hoping that we could produce the report using two separate cursors. What do you think?

Thanks for the response,

Tom