Subtotals on Hidden Duplicate Rows in Report

[AKWells]

Hello, and thanks for your help in the past. I have a report that has a Project Total Cost column that I need to subtotal in each group. The report uses a sub-report to display funding summaries for each project, so that the summaries can overlap the report's record data. I have two subtotals already set up, one to subtotal the Amount Requested and another for Amount Approved. The problem is setting up a subtotal for Project Total Cost, because it repeats for every different funding round. On the attached image, the Project Total Cost for the first project repeats 4 times, but Duplicates are set to be hidden so it only shows once. Because the Project Total Cost data repeats so often, the subtotals end up very large.



I'm not sure how to go about fixing this. Any help would be appreciated. I've attached a PDF of the report as well as the database. The report I'm trying to edit is called rptAPL_WithSubs.

[June7]

This is always a difficult issue to resolve. Glad I don't have any reporting requirements like this.

Possible options:

query (with same filter criteria as the report) that does the summation by ProjectCount grouping then do a DLookup on that query

DSum on the raw data and use filter criteria in the DSum

a subform of the detail records instead of everything in one dataset

[AKWells]

Thanks for the suggestions. I'll begin looking at the possibilities.