running total of formula that pulls from subreports 1

[Hueby]

Hey all, I have the formula below in my group footer (which pulls values from subreports):

whileprintingrecords;
shared numbervar mat;
shared numbervar hcost;
shared numbervar eq;
numbervar total;

total := mat + hcost + eq;

My question is... is there anyone way to get a running total of this to put in my main report footer?

...or would I have to do some type of running total in each subreport and then add them all in the main maybe?

Thanks for any help!

 

[lbass]

You could modify your formula so that it reads:

whileprintingrecords;
shared numbervar mat;
shared numbervar hcost;
shared numbervar eq;
numbervar total;
numbervar grtotal;

total := mat + hcost + eq;
grtotal := grtotal + total;
total;

Then in the report footer, add a formula:

whileprintingrecords;
numbervar grtotal;

-LB

 

[Hueby]

ohhhhhhh! Cool, thank you!