Sub report values by formula defined group

[IceRuby]

Using Crystal Version 10, ODBC connection to SQL database.

I have created a report that lists payroll transactions by branch, pay entity and then a formula defined group. I have added a subreport to split pay entity as I need to report to list in format of Branch and then pay entity.

QLD 001
$$$
QLD 018
$$$
WA 001
$$$
WA 018
$$$

So report format is:-

MAIN REPORT (Non Exec)
#GRP 1 BRANCH
#GRP 2 PAY ENTITY = 018 (record selection limited)
#GRP 3 - Formula to define following criteria (also containing amount summary)
Salaries & Wages $5,000,000
Exempt Tran $ 50,000
Bonus & Allowance $ 1,000
Employer SGC $ 2,000
Salary Sacrifice $ 5,000

SUBREPORT (Exec)
#GRP 1 BRANCH
#GRP 2 PAY ENTITY = 001 (record selection limited)
#GRP 3 - Formula to define following criteria (also containing amount summary)
Salaries & Wages $1,000,000
Exempt Tran $ 20,000
Bonus & Allowance $ 1,000
Employer SGC -$ 2,000
Salary Sacrifice -$ 5,000

I now need to create totalling value between Group 3 Main Report and Group 3 Subreport values. Have created a shared numbervar but am having issues in only last value is passed to main report.

Need formula to complete following:-
MAIN REPORT #GRP 3 values + SUBREPORT #GRP 3 values
Salaries & Wages $6,000,000 (main report + subreport)
Exempt Tran $ 70,000 (main report + subreport)
Bonus & Allowance $ 2,000 (main report + subreport)
Employer SGC $ 0 (main report + subreport)
Salary Sacrifice $ 0 (main report + subreport)

Appreciate your help

 

[lbass]

Where is the subreport located? If it is linked to the main report, how is it linked? Where do you hope to display the summarized values?

-LB