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
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