Grand Total of several reports on one


G

Guest

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
 
Ad

Advertisements

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.

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) +
.. . .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top