Totaling SubReports 1

[sandora]

I have 4 subreports in one main report. The subs are summaries for different companies and contain totals for each. I need to total all of the subs for a grand total. Can this be done and if so, how?

 

[sandora]

Sorry, I'm using ver XI and an AccessDB.

 

[BobSuruncle]

Create Shared variables in the subreports and store the values that you want to accumulate.
e.g.
In subreport 1
@Store the vars
Shared NumberVar sub1_gt := Sum({YourField});

In subreport 2
@Store the vars
Shared NumberVar sub2_gt := Sum({YourField});

etc. for the other subreports.

In the main report, add these values together.

e.g.
In Main report (in a section that occurs after the subreport fires)

@Accumulate
Shared Numbervar sub1_gt;
Shared Numbervar sub2_gt;
Shared Numbervar sub3_gt;
Shared Numbervar sub4_gt;
sub1_gt + sub2_gt + sub3_gt + sub4_gt

Bob Suruncle

 

[sandora]

I've named the formula (fieldname shared) and used this:

Shared NumberVar sub1_comamt:= Sum ({@Commission Amount});

it gives me an error that a number is required here and highlights after the =. I tried it on each Sum and it gives the same error. Also I have 8 totals in each report. Can I make one formula for all or do they have to be separate formulas?

 

[sandora]

I figured out the number thing, it is currency, and CurrencyVar seems to work with that part.

 

[sandora]

I just want to thank everyone on this sight who helps with these problems. I've learned so much in the last month and you've made me look really good. I actually got this thing to work. Again, thanks so much.