Summaries of variables 1

[Shnibnib]

I have a shared number variable in a subreport in Details (a) section. This is passed into the main report and a formula field calculates this and returns a number.

I want to then produce a sum of these at the bottom of the report, but I cannot seem to do this.

Could anyone help?

Thanks

Shnib

 

[lbass]

Let's say your calculation formula that references the shared variable is in detail_b. You can amend it as follows to add a variable that will collect the results across records:

whileprintingrecords;
shared numbervar x;
numbervar calc := x * .05; //your calculation
numbervar sumcalc := sumcalc + calc; //this accumulates it
x //this displays the original calcultion

Then in the report footer, place a formula like this for display:

whileprintingrecords;
numbervar sumcalc;

-LB