Calculating across reports

[paulhh]

Sorry not sure even what to search on in the discussion area for this.

Figured out how to put three subreports on one report but now I need to add numbers from each report for a grand total at the bottom. Could you direct me in the right direction?

Paul

 

[WayneRyan]

Paul,

You can put an "unbound" control in the report's footer and
set its default to 0. In the OnClose or PrintFooter event of
each subreport, you can add that subtotal to your report's
new footer control.

hth,
Wayne

 

[paulhh]

Think I mixed report & subreport

Wayne,
What I meant to say was I need to grab a subtotal from each subreport and add to the report.

Example.

Report
Subreport 1
Manager1 Cust expected order total
Manager2 Cust expected order total

Subreport 2
Manager1 Work in process (WIP) order total
Manager2 Work in process (WIP) order total

Subreport 3
Manager1 Completed order total
Manager2 Completed order total

Want to add to bottom of report

Manager1 Cust expected + WIP + Completed
Manager2 Cust expected + WIP + Completed

 

[WayneRyan]

Paul,

I know.

Put two unbound (not relating to your tables) controls on
your report footer. They are not in your tables or queries.

Use the Report Footer's OnPrint event to add the following
code for each of your subreports:

Me.Control1 = Me.Control1 + Me.SubReportsTotal1
Me.Control2 = Me.Control2 + Me.SubReportsTotal2

This assumes that Control1 is for Manager1 and
Control2 is for Manager2. Also the Me.SubReportsTotal1
is the "running sum" for each subreport.

This could also be done with some query work, but this
is straightforward and simple.

Wayne



Wayne

 

[paulhh]

Wayne,

Thank you will try it.
Am kind of a slow learner.
Sure appreciate your help.
Paul