Crystal Reports adding values from another subreport

Message

   Hello:

I have a Crystal XI report containing inventory items.  These items come from a SQL 2005 table.

In this report, I also have a subreport that pulls the item quantities from an Excel spreadsheet. These items and quantities are in a group footer.  When I generate this report, the data in both the main report and the subreport are correct.

In this main report, below this group footer, I have placed another group footer that needs to show customer totals.  I need to have this footer show the quantities, in total, for all items for each customer.

The problem, though, is that the "MainReportTotal" is from another subreport.  You see, I'm trying to total item quantities per customer.  The problem is that those quantities are from a subreport in another group footer--not simply a field in the main report.

Here's the problem that I'm running into.  I was able to get this shared variables stuff to work, except for one thing. In the lower-right hand corner is a figure: 2,220. This is the total field that I need (i.e. "Customer Totals"). But, it should be 2,220 plus 1,098. What's happening is that the Customer Totals field is only pulling the first record (i.e. the first inventory item in the report for each customer).  For this particular customer, there are two inventory items: one for a quantity of 2,220 and the other for 1,098.  The Customer Totals field should add these two fields together. But, it should be totaling all items for each customer.  It should be adding 2,220 plus 1,098.

I am using these shared variables, as best as I can. I don't know what further info to give other than to say that the subreport is in Group Header 2 which represents customer ID, the header declaring the shared variables is in the Report Header, and my Customer Totals field is in Group Footer 2. 

Any ideas?