Summary Fields 1

[gloshar]

I am trying to modify an existing report to include totals. This report currently shows totals in Group Footer 2 (by project). I need to total these amount in Group Footer 1 (by manager) and also at the end of the report (Grand totals). When I inserted the summary fields for the two totals I got unexpected results. One figure (expenses)gave the expected result but the contract amount gave an unexpected figure. When I look at the details, I see why - contract amount appears each time there was a corresponding expense for that project. The field that appears to be a total in the GF2 is actually not a summary field but a table field.

PH Manager ID Project ID Contract Amt Expenses
GH1 EA
GH2 123
GF2 $10000 $4000
GH2 456
GF2 $5000 $2000
GF1 Manager Totals
GH1 JW
GH2 789
GF2 $20000 $10000
GF1 Manager Totals
RF GRAND TOTALS

Is there a way that I can set this report up so that the summary is calculated based on the field that appears in GF2 and not the details? Or, is there a way to set up the report so that the expenses are calculated in the details by project ID so that a detail line is not created for each expense transaction? I am using CR version 9.

Thanks in advance for any advice.

 

[lbass]

Insert running totals where you select the {table.contractamt}, sum, evaluate on change of group (projectID). Use two separate running totals, and for the manager subtotal, choose reset on change of group (manager), and for the grand total, use reset never. The running totals must be placed in footer sections (group, report).

-LB