Hi Ruben,
You can use cursor to prepare results including subtotals per account.
Then you use that cursor to built your report instead of original tables.
It would be also good idea to prepare small session object acting like
sort to of balance(s) server, being able to return total for given account,
or group of accounts.
In this case preparation/population of cursor can be very simple thing to do.
Rgds++
>I have a report in which I'm wanting to generate the totals for all matching account numbers. When account number "B" is next, need the subtotal for that number, etc.
>
>I figured out the total for the entire database, but looking for subtotals based on the account number.
>
>
>Thanks in advance.
>
>AlexFher