Have a report that does not have any groupings. Only a detail section. I am trying to use a running total to calculate a subtotal all within the detail section.The reason is we need multiple subtotals but all within the detail section of the report.

So here is an example of the items listed on the report:

Item A               100.00
Item B               100.00
Item C               100.00
SUBTOTAL             300.00

Item D               200.00
Item E               100.00
SUBTOTAL             300.00

We want the running total to add the items and put the running total amount where you see above. We have done this but we also need to reset the running total when it encounters a SUBTOTAL.

So in the example above if I were to put our running total beside the amounts also with the knowledge the running total needs to be reset when it encounters a subtotal here is what we get:

Item A               100.00        100.00
Item B               100.00        200.00
Item C               100.00        300.00
SUBTOTAL               0.00

Item D               200.00        200.00
Item E               100.00        300.00
SUBTOTAL               0.00     

So as you can see the SUBTOTAL is at 0.00 since we need to reset it. All we need is for the last running total from the line above to pass down to the subtotal line and we are good.

Any suggestions or postings would be greatly appreciated.