summary for multiple sub reports

[sydeburnz]

i have one report that shows all employees grouped by store, then region. this is accomplished by having a sub report for each region which has sub reports for each store.

Main Report
--By Region Sub Report
--By Store Sub Report

What I would like to accomplish is have a summary that will show me average or totals on some of the fileds for all subreports on that page. As of now when I add a summary, it just does it for one store which is the first sub report on that page.

+++++++++++++
Region Sub Report
store 1 Sub Report
emp 1 -- -- --
emp 2 -- -- --
emp 3 -- -- --


store 1 Sub Report
emp 1 -- -- --
emp 2 -- -- --
emp 3 -- -- --

Summary -- -- --
+++++++++++++++

my summary only uses the data from store 1 instead of store 1 and store 2

[V361]

Here is an example of how to add two entries.

subreport 1 formula:
whileprintingrecords;
shared numbervar x:= sum({table.field})

subreport 2 formula:
whileprintingrecords;
shared numbervar y:= sum({table.field})

Formula in the main report:
whileprintingrecords;
shared numbervar x;
shared numbervar y;
x+y