Grand Total of several reports on one

J

Joe C

Hello,

I have several different reports that all have a sum on them. I need to sum
all of those totals on one master total report. Any suggestions.

On a second note: When I have tried to put them all on one report and one of
the elemenets returns a no value the answer in the grand total report returns
an error.

Thanks JC
 
M

Marshall Barton

Joe said:
I have several different reports that all have a sum on them. I need to sum
all of those totals on one master total report. Any suggestions.

On a second note: When I have tried to put them all on one report and one of
the elemenets returns a no value the answer in the grand total report returns
an error.
Click to expand...


The main report text box would use an expression like:

=IIf(subrpt1.Report.HasData, subrpt1.Report.sumtextbox, 0) +
IIf(subrpt2.Report.HasData, subrpt2.Report.sumtextbox, 0) +
.. . .
 
Top