Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula to add unrelated subreports

Status
Not open for further replies.

Lisa5781

Technical User
Jul 25, 2005
5
US
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?
 
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
 
Except I don't think you will be able to extract totals from inserted crosstabs.

-LB
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top