I have report with one subreport that uses a shared variable. The main report is grouped by market then by location. The subreport is grouped by market only. I created a shared variable in the subreport to sum revenue. I then created a shared variable in the main report to access the shared variable from the subreport.  The first record of the subreport dsplays the shared variable as zero. The second record display the shared variable that is spposed to go with the first record. So in a sense, it seems as if the shared variable is one record behind when displayed on the main report. Any suggestions?

Edited by cwhitmore - 18 Nov 2009 at 12:19pm

I would like to use it in the group footer. The shared variable is one record behind, so the very first record is "0", the next record has a value that should be in the first record. Is there a way to supress the first record of the sared variable.