Hello everyone! Is it possible to have a Leading Grand Summary contain all the totals for Subsummary Part Break fields? I have 2 Subsummary parts and each has a break field. The first Subsummary

Hello everyone! Is it possible to have a Leading Grand Summary contain all the totals for Subsummary Part Break fields?

I have 2 Subsummary parts and each has a break field. The first Subsummary Part (Leading) has a break field "Account Number" and the second Subsummary Part (trailing) has a break field of "Department". I want my Leading Grand Summary to show all the break field instances of "Account Number" from the 1st Subsummary Part and display grand total for those instances.

Report

----------------------------

Leading Grand Summary

Account Number Total Number

123456789 10

987654321 20

---------------------------------------------

Subsummary (by Account Number)

123456789

Subsummary 2 (by Department)

Department A 5

Department B 5

Subsummary (by Account Number)

987654321

Subsummary 2 (by Department)

Department A 10

Department B 5

Department C 5

I hope you get the idea from this little sketch. My report has 2 Subsummary parts, 1 "Account Number" (Leading), and 2 "Department" (Trailing). How can I get the Leading Grand Summary to display the totals of my the break fields ("Account Number") this way?

Thanks in advance!

J