Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub report values by formula defined group

Status
Not open for further replies.

IceRuby

Technical User
Jan 20, 2004
85
AU
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top