Group total in subreport

[Sunny]

I am tired of applying different different logics to get coorect total on
subreport and main report. I want to start from scratch with your great
ideas. Let me explain you waht I need.

My main report is grouped by Area Office and then Client Id. And I have sub
report in Client Id Footer. In main report detail section there is nothing
to print. Client Id header section I want to print client information and
opening balance. Now subreport is grouped by Account Type and then Category.
In Account Type header section, I want opening balance for the category. In
Category header section, I need Opening balance for Category. In detail
section all transaction will be displayed. And Finally I want Category
total, Account Type total in relavant footer and Client total in Client
footer after subreport.

In short it should look like as follow:

Area : 1
Client1 : Id, Name, Client Opening Balance
AccountTypeA A/c Type Op. Balance
Category C1 Category Op Balance
Trx1 Trx
Amt.
Trx2 Trx
Amt.
Category C1 Category Closing Bal
Category C2 Category Op Balance
Trx1 Trx
Amt.
Trx2 Trx
Amt.
Category C2 Category Closing Bal
AccountType A A/c Type Closing Bal
AccountTypeB A/c Type Op. Balance
Category C3 Category Op Balance
Trx1 Trx
Amt.
Trx2 Trx
Amt.
Category C3 Category Closing Bal
AccountType B A/c Type Closing Bal
Client 1 Client Closing Balance

Client 2
AccountTypeA A/c Type Op. Balance
Category C1 Category Op Balance
Trx1 Trx
Amt.
Trx2 Trx
Amt.
Category C1 Category Closing Bal
AccountType A A/c Type Closing Bal
Client 2 Client Closing Balance


Which is the best way to calulate correct closing balance?

Thanks for looking the issue.