Andi,

You need to define report.data group on your name or group key. Then that creates a group header and footer band for that grouping. In the footer band you put fields similar to your total band that reset when the group key changes.

-myron kirby-
myronk@flash.net
-------------------------------------------
>>How can I do that using Report Designer ? I have tried using variables but still can't get the correct TOTAL (700).
>>
>>>> Use Title/Summary option at Report pad menu. Check Summary band option on Report Summary box. Place field to be summed up and the Summary portion of the Report form. Click calculation button and set option to Sum and Reset: should be End of Report.
>>>> I presume you already know the group option for group sub-totals, if you don't, please reply...
>
>I do use Summary band and put the field LIMIT on it and set Calculation option to SUM and reset at end of report but I get the total 1200 while actually it should be 700.
>
>Here is my sample data: John is one customer, Marry is also one customer and so is Tony.
>
>Name Limit Payment
>John 100 5
>John 100 10
>John 100 30
>Marry 300 20
>Mary 300 50
>Tony 300 80