the subreport is grouped by market, the main report is grouped by market and location. My data is totaled in the subreport by market and the data in the main report is totaled by location. In short, the market subreport is an aggregate of the main report. the data in the main report is displayed in location footer and the data in the subreport is displayed in the market footer. I would like the shared value from the subreport displayed in the main report. So far when the shared value is displayed in the main report, it is one record behind. So on the first record the shared value is "0", but the second record the shared value is "16". The "16" i want displayed on the first record.

I really appreciate your follow-up.  I was able to get my report to work with a little trickery of grouped fields. It seems i was getting "0" on the first record because the subreport that uses the shared varible was not being calcluated before i displayed the results of the shared variable, in this case the market results needed to be calculated first. So i created another market field, "market2" in the database. Then i inserted a group based on the "market2" field. I placed another copy of the subreport in the original "market" header. Now, when viewing the results of the shared variable when grouped by location, i get the right result.

Edited by cwhitmore - 23 Nov 2009 at 1:11pm