Calculation

[Guest]

I have a subreport that runs from a query, in that query I have a field
called "ActiveInActive", I put "true" in the criteria so that any record
marked "true" would pull into the subreport. This works fine. Now I am
trying to calculate in the main report those records that pulled over along
with 3 other subreports. Here is my calculation in the main report.

=[rptPMRentRollTab1BaseRent
subreport].[Report].[rentamount]+[rptPMRentRollTab2BaseCAM
subreport].[Report].[camamount]+[rptPMRentRollTab4BasePtax
subreport].[Report].[PTAXamount]+[rptPMRentRollTab6BaseINS
subreport].[Report].[INSamount]+[rptPMRentRollOpCostTab
subreport].[Report].[Amount]

Yesterday it was suggested to me that I first put a calculation in the
subreports footer, then use the footer field name in the above calculation.
I tried that and in both cases it just uses the first record and skips over
any other record.

This report returns the total active charges for tenants. But some have
more than one type of rent. The information pulls over to the report
correctly, I just can't get it to calculate. Does anyone have any other
ideas?

 

[Duane Hookom]

You would need to have a total text box in your subreport footer and
reference this text box from your main report.

You may need to use something like:
=IIf([rptPMRentRollTab1BaseRentsubreport].[Report].HasData,
[rptPMRentRollTab1BaseRentsubreport].[Report].[rentamount],0) + ...