I have the following SQL-result :

Name Limit Payment
John 100 5
John 100 10
John 100 30
Marry 300 20
Mary 300 50
Tony 300 80

I want the Report Design to print / preview as follows:
Name Limit Payment
John 100 5
10
30
--------------------------------------------------
100 45

Marry 300 20
50
---------------------------------------------------
300 70
Tony 300 80
---------------------------------------------------
300 80
---------------------------------------------------
TOTAL 700 195

How can I do that using Report Designer ? I have tried using variables but still can't get the correct TOTAL (700).
I asked my friend (a Delphi developer) to do this using Delphi report designer just to get an idea. I saw that he used variables in the report designer then I tried using variables in VFP report designer but I failed. What have I done wrong ?

Your help is highly appreciated.
Regards,
Andi Hidajat