Summary of totals per group

rbuser

Hi,

Here is what I have till now:
Report with two groups
- Employee
- Type

Subreport in detailsband per employee and type
In the subreport column "hours" is summarized in the summaryband.

So:
Employee 1
---Type 1
-----details 1 hours
-----details 2 hours
-----details 3 hours
---summary = 6 hours
---Type 2
-----details 1 hours
-----details 2 hours
---summary = 3 hours

Employee 2
---Type 1
-----details 2 hours
-----details 3 hours
---summary = 5 hours

What I want to do is summarize the total hours for each employee behind the
name of the Employee (so creating a total of the hours over all types for
that employee)
Employee 1 -> total 9 hours
Employee 2 -> total 5 hours

Can anybody tell me how to accomplisch this.
If it can't be done in the groupheader, maybe it can be done in the groupfooter
(or elsewhere)?

Please give me detailed directions on how to do this.

With kind regards,
Stef

nicocizik

Hi Stef,

Try placing a TppVariable next to the Employee in the group header with
LookAhead set to True. Then each time you calculate the summary for each
type, update the variable in the group header by adding that value on. If
you reset the variable after the group breaks, you will essentially get a
group summary in the group header.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hello Nico,

Your solution works perfectly.
Thank you very much.

Regards,
Stef