>In my detail band I have to accumulate a fld value each time it loops through a record. On the group break I need to display the accumulated fld value and zero it out to start again on the next group of records..
>The problem is, I need to do this logic in the report writer. Any ideas?
>In code, I would do something like this:
>Do while !eof()
>Final_number = final_number + fld_value
>Skip
>Enddo
>?final_number
Set Data Grouping in the Report Menu to group by the field you're tracking. Copy the field, and paste it into the group footer band.
Right-click, choose Properties, then Calculations...
It should default to reset on the field you're grouping by. Choose Sum.
That should be all you need.