Cross Calculation

[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?

 

[Marshall Barton]

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?

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)