CR 10
SQL 2000
I am having difficulty getting the total from my sub-report to interact with the totals on my main report. I have done the following:
Added to sub-Report:
whileprintingrecords;
shared currencyvar TotalResidual;
shared currencyvar TotalResidual := Sum ({AH_accResidualByClient.ResidualBalance});
shared currencyvar TotalResidual;
Added to main report:
whileprintingrecords;
shared currencyvar TotalResidual;
and
Sum ({AH_accAgedAccountsReceivableByPrimaryClientAssignment;1.BalanceDue}) + {@TotalResVar}
The total of @TotalResVar is showing as zero in the footer of the report but it has a correct amount in the sub-report.
Any help would be great.
Thanks
BB
SQL 2000
I am having difficulty getting the total from my sub-report to interact with the totals on my main report. I have done the following:
Added to sub-Report:
whileprintingrecords;
shared currencyvar TotalResidual;
shared currencyvar TotalResidual := Sum ({AH_accResidualByClient.ResidualBalance});
shared currencyvar TotalResidual;
Added to main report:
whileprintingrecords;
shared currencyvar TotalResidual;
and
Sum ({AH_accAgedAccountsReceivableByPrimaryClientAssignment;1.BalanceDue}) + {@TotalResVar}
The total of @TotalResVar is showing as zero in the footer of the report but it has a correct amount in the sub-report.
Any help would be great.
Thanks
BB