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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting a grand total from numbers in multiple subreports

Status
Not open for further replies.

bndarby

IS-IT--Management
Joined
Dec 5, 2002
Messages
1
Location
US
I am creating a main report that has 15 subreports. The subreports contain numbers of fire rolls. I need to know how to get a grand total of sets of numbers generated by the subreports.

Thanks Brian
bndarby1@bellsouth.net
 
You need to create a formula in each subreport that creates a shared variable (e.g. Shared numberVar Sub_1_Result) and loads it with the value to be passed back to the main report.

Then after all sub reports have you need another formula that declares all of the shared variables and then sums them. Display the result.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top