Grand Totals For Shared Variable 1

[rwn]

I have a shared variable from a sub report and showing its data in the main report in the GF1 Section. I would then Like to take this data in the GF1 section report and obtain a grand total in the Report Footer section.

The Groupings that I have are first by:

GH1 = Employee ID.
GH2 = Date by Day, with a parameter for date range.

 

[lbass]

If the subreport is in GF1a, then create a formula like this in GF1b:

whileprintingrecords;
shared numbervar x;//your shared variable
numbervar sumx := sumx + x;

Then in the report footer use this formula:

whileprintingrecords;
numbervar sumx;

-LB

 

[rwn]

Thanks again. I will try on Friday and let you know the results.