I'm working on a report that looks like:

teamCaptain  (a group)
    projectNum    (a group)
        employee  (detail band)

The detail band shows all the employees that worked on a project that a teamCaptain managed. There could be many teamCaptins and each one can have many projects. I've got this part working.

Now, I need to summarize all the projects for each teamCaptin. In the teamCaptain group footer I need to show a list of all the employees that did work for that teamCaptain and the total hours for all the projects worked.

How do I do add the summary portion in the group footer?

Sample:

Zaphod
  001
    Ford      3
    Trillian  4
  002
    Ford      6
    Marvin    2

  Team Captain Summary
    Ford      9
    Trillian  4
    Marvin    2

(the next teamCaptain)