The report is to show total scrap and rework reported from the production floor for a given time frame. The main report calculates the reworks reported and the sub report calculates the scrap reported. The data is grouped by day and totaled for the week or month depending on selected dates. I've got a total for each day in the sub report and want a total for all days to show in the main report footer. I'm sure I need to have a shared variable but can't figure out how it needs to be setup.

Thanks for the reply lockwelle. I didn't get it to work the way you described, mainly because they didn't give me time to finish. I ended up breaking it into 2 reports that they run separately.