Formula to add unrelated subreports

[Lisa5781]

I have a report that contains seven subreports (which are crosstab reports). None of the sources are linked, nor can they be linked. I need to do a sum on the totals of each report. Running sums doesn't work. Any ideas?

 

[TheBlondOne]

It sounds like you need to create totals in each sub-report. You can then assign these totals to differently named shared variables and then pass this information into the main report.

What you will be able to do then is to total up all of the shared variables in a formula and that will give you your overall total.

Hope that is of some use.

Steve

 

[lbass]

Except I don't think you will be able to extract totals from inserted crosstabs.

-LB

 

[synapsevampire]

What LB is alluding to is that you might use formulas such as the following in each subreport:

shared numbervar sub1sum:= sum({table.amount})

Repeat and use unique variable names for each subreport.

Then after each subreport has run in the main report, you can reference it's shared variables in a main report formula as in:

shared numbervar sub1sum;
shared numbervar sub2sum;
shared numbervar sub3sum;
etc...

"Subreports total = " & sub1sum+sub2sum+sub3sum+etc...

-k