Cross Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to cross calculate a different fields from 3 subrpt in a Main
Report.

Example: rptMainClient: Contains 3 sub reports.
subrptRufugee
subrptImmigrant
subrptAsylee

In the report, footer of each sub report there is a calculated field that
counts the Clients in each report. =Count([ClientID])0

On the Main Report, I would like it to total all three calculated fields in
the sub reports for one total. Any Ideas?

On the Main Report I would like it to take total all three calculated fields
in the sub reports for one total. Any Ideas?
 
Rose said:
Is there a way to cross calculate a different fields from 3 subrpt in a Main
Report.

Example: rptMainClient: Contains 3 sub reports.
subrptRufugee
subrptImmigrant
subrptAsylee

In the report, footer of each sub report there is a calculated field that
counts the Clients in each report. =Count([ClientID])0

On the Main Report, I would like it to total all three calculated fields in
the sub reports for one total. Any Ideas?

On the Main Report I would like it to take total all three calculated fields
in the sub reports for one total. Any Ideas?
Click to expand...


Use a text box in the section that contains the subreports:

=IIf(subrptRufugee.Report.HasData,subrptRufugee.Report.totR,0)+
IIf(subrptImmigrant.Report.HasData,subrptImmigrant.Report.totI,0)+
IIf(subrptAsylee.Report.HasData,subrptAsylee.Report.totA,0)
 
Back
Top