Crystal 8.5 and DataSource Type SQL
I would like to resolve without sub-reporting, if possible.
Two tables (1. Sal Projection & 2. Exp Budget) at different agregation levels and want to sum both up by
Field A : Dept Budget (CF3 linking tables by this field)
Field B : Account (linking tables by this field)
Field C : Fund (linking tables by this field)
Field D : Sal Proj Amount (from table 1)
Field E : Expenditure Amount (from table 2)
Field F : Diff Amt. : Sal Proj Amt - Exp Budget Amt
The issue is that Sal Projection Actual Paid Amt is detailed all the way down to the employee id level and Expense budget has accounting periods to sum up to get the Expenditure Amount used to compare to the Sal Projected Amount.
I can easily get one side of the equation to not duplicate by placing the detail fields A - C and D or E from one table in the detail section suppressing and grouping in the footer using max of and selecting Database/Select Distinct Records.
Is there a way to get both tables in the report with amounts summed up to compare without running into the duplicates issue? I would like to do this without subreports if possible.
I would like to resolve without sub-reporting, if possible.
Two tables (1. Sal Projection & 2. Exp Budget) at different agregation levels and want to sum both up by
Field A : Dept Budget (CF3 linking tables by this field)
Field B : Account (linking tables by this field)
Field C : Fund (linking tables by this field)
Field D : Sal Proj Amount (from table 1)
Field E : Expenditure Amount (from table 2)
Field F : Diff Amt. : Sal Proj Amt - Exp Budget Amt
The issue is that Sal Projection Actual Paid Amt is detailed all the way down to the employee id level and Expense budget has accounting periods to sum up to get the Expenditure Amount used to compare to the Sal Projected Amount.
I can easily get one side of the equation to not duplicate by placing the detail fields A - C and D or E from one table in the detail section suppressing and grouping in the footer using max of and selecting Database/Select Distinct Records.
Is there a way to get both tables in the report with amounts summed up to compare without running into the duplicates issue? I would like to do this without subreports if possible.