Need to add totals from subreports in Detail section of report
Posted on 2009-03-29
In the Detail section of a report, I have 4 subreports: Employees, Subcontractors, Materials, and Equipment. Each subreport has one total calculated in its report footer. In the Group Footer section, I need to add up all the totals for Employees, and add up all the totals for Subcontractors, and add up all the totals for Materials, etc.
Let's take just the Employees subreport as an example. On that subreport's report footer is a textbox named TotEmpl. So in the Group Footer section of the main report, I have a textbox with this calculation: =sum([Employee Hours and Cost].[Report]![TotEmp]), but it doesn't work, and I don't know why. When I try to run the report, it shows me a parameter box saying "Employee Hours and Cost.Report!TotEmp"
I sure hope someone can help me....