Can I repeat group footer records at the end of the report?

[PhilB2]

My report has Group Header 1 followed by a detail section. Each group begins on a new page. A total line containing a running total appears in Group Footer 1. About a dozen groups appear in the report. Each page has a header, detail section and total line.

I have a chart in the report footer, and after the chart, I'd like to have the dozen total lines appear again.

Currently, only the grand total appears, and when I insert the total line, only the last entry appears.

I could create 12 separate running total fields and insert all 12 fields in the report footer. Is there an easier way?

 

[PhilB2]

Update: I tried creating a new running total field for one member of the group; that didn't work. I tried creating a formula field that took the value of the original running total field, and that didn't work. Maybe creating a variable would work if I populated it correctly, but I don't think I know how.

 

[PhilB2]

For a workaround, I saved the report as another, and hid all the sections except the report header and footer, and group footer 1. I'm not sure how I'll get the chart and total lines on one page. Even if I do, I still would like to know if there's a way to keep the detail pages in the same report.

 

[lbass]

Are you certain you need to use running totals? How are they set up? Are you using any group selection?

-LB