Transaction Report with subtotal for credit and debit

[neville at taygon.com]

I am looking at the transaction report. On the display tab, I have choose
in amount the option "double". This way I have two columns: debit and
credit.

At this moment I have:

Cash
05/05/10 loan ----- 1200
05/05/10 service A -------- 174.17
05/05/10 service B -------- 151.37
05/13/10 service C -------- 819.37
TOTAL for Cash --------------------- 55.09

I would like to have the sum for each column, like this:

Cash
05/05/10 loan ----- 1200
05/05/10 service A -------- 174.17
05/05/10 service B -------- 151.37
05/13/10 service C -------- 819.37
TOTAL for Cash ---- 1200 - 1144.91 - 55.09

There is an option for that? If not, has anybody done a custom report with
that sums? Or at least some scheme script that shows sums that I can look
at and find a way to make my custom report.

Thanks in advance.

Neville A. Cross