Combining report & subreport totals

J

jnew

Greetings,

I hope this is just some simple thing I'm overlooking. My report displays
teaching schedules for community college instructors. Each instructor teaches
multiple sections and each section may include multiple labs (displayed
through a subreport). I need to add the sum of credit hours from the labs to
the sum of credit hours from the courses.

I have divided the report into the following Grouping Sections:

Instructor Group Header:
{Instructor data controls}

SectionID Group Header:
{Section data controls}
{"LabSubreport" w/report footer for total lab credits}

Detail Section: No controls

SectionID Group Footer:
{"SumLabCr": [LabSubreport].[Report]![TotalLabCredits]}
{"LabSum": =Val([SumLabCr]), Running Sum: Over Group}
Q: Does the running sum control belong in this section?
It only gives me the sum per section, but I need
to sum up lab credits from multiple sections.

Instructor Group Footer:
{"TotalSecCr": =Sum([SecCredits])}
{"TotalLabSum": =Val([LabSum]), Running Sum: Over Group)
This control only captures labs from the last section.
{"TotalInstCr": =[TotalSecCr] + [TotalLabSum]}

This structure does not work. If I change the running sum property to "Over
All" it does not break the lab credits down per instructor.

I hope someone with lots more knowledge than me can:
1) decipher this lengthy description
2) help me troubleshoot the problem

Thanks in advance for your consideration.

jn
 
Top