Crystal Reports summary of one group in another group footer

See more:

VB

CrystalReports

Here is an update:
I can group the report by candidate key. So I can use subreport and place it the the group footer for each candidate.
But when I use a subreport and group by candidate key to link it to report, and also group by "job" (actor, write, e=unemployed) etc, the I expected the subreport to run for each candidate .
But I see the complete subreport on each candidate footer!!
Can some one please help!

I am trying to print a report of this format:
Name (Formula: Lname,FName)
Details for that Name group
Summary of Group1(by week)
Sumary of Group2 (By Name)
Summary of group 3 in group2 footer

I want a consolidated summary of one group
Eg:



Somerset, Mark

6-12-2009 Writer $400

7-12-2009 Actor $500

Year 1 $900

6-12-2010 Unemployed $0

7-12-2010 Writer $600

Year 2 $900


Writer $1000
Actor $500
Unemployed $0
Somerset, William

5-12-2009 Writer $300

7-12-2009 Actor $300

Year 1 $600

5-12-2010 Unemployed $0

6-12-2010 Writer $800

Year 2 $800


Writer $1100
Actor $300
Unemployed $0

The report is grouped by Name which is a formula. So I cannot create a subreport!
Can anyone please help!