>>>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

If you're able to do any manipulations in Report Designer, you can use Init method of DE in order to use Sergey's suggestion.