>>I have a result set that was created from joining two tables. The result set was created in some third party software so I can not change the Query.
>>
>>I am using the first footer band as the detail band (cust#+order# below). Now i want my second footer to sum the amounts that are in the first foot, not to sum the detail record amounts.
>>
>>
>>cust# order# order_tot item#
>>12345 4444 100.00 331
>>12345 4444 100.00 332
>>12345 4455 40.00 787
>>12345 4455 40.00 787
>>32434 4322 20.00 656
>>
>>I want the report to be
>>
>>12345 4444 100.00 2
>>12345 4455 40.00 2
>> ------- ----
>> 140.00

>Can you run one more SELECT and use it's result in a report?
SELECT * from resultset ;
GROUP BY 1,2 ;
INTO CURSOR myReport
>-- sb --
>

A subroutine, that I can not easily change, creates the cursor and then throws me into report designer.

Brenda