Hi,
I'm trying to create totals on some data that i have drawn from a subreport. The data is a list of employees and their tax cost being grouped by an object code (i.e. 51722). Now i've had no problem pulling the data out of the subreport, but when i try to summarize the data on the main report, the data will not total properly when ever the data continues onto a new page. When the data is all on the same page, it totals fine.
For Example: Bottom of page 1 shows:
Employee Taxes
51722 Miner:
Robert 500 (-->Placed variable VTaxesAN8)
Pat 1000
Then the data continues onto page 2:
Matt 800
Michael 900
Total for 51722 Miner 1700 (-->Placed variable VtaxesOBJ)
The total for the object 51722 should be 3200, not 1700. The total only adds what was printed on page 2 and ignores what was on page 1.
Anyone have any ideas?
My subreport formula for the shared variable is:
WhilePrintingRecords;
Shared numberVar VTaxesAN8;
VTaxesAN8 := VTaxesAN8+Sum (
{@Employer Taxes}, {F0618.YTAN8})
On The Main report formula for displaying the taxes by person is:
WhilePrintingRecords;
Shared numberVar VTaxesAN8;
VTaxesAN8
Formula On The Main report formula for Totaling the taxes by Object 51722 is:
WhilePrintingRecords;
Shared numberVar VTaxesOBJ;
VTaxesOBJ :=VTaxesOBJ+{@Place Variable - TaxesAN8}