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

Displaying totals from Subreport on Main Report

Status
Not open for further replies.

EliseFreedman

Programmer
Dec 6, 2002
470
GB
Hi There

I have a report which as well as containing its own data with its own total also contains a subreport with its own total. I would like to have a text box on the main report which basically is a grand total and sums up the two totals. However, when I try to do it, all I am getting for the result is #name.

the total on the main report(text27) is =Sum([SumOfexpr1])
the total on the subreport is =Sum([order_value]). This is contained within text39.

How do I display the grand total on the main report. I have tried
=[Reports]![orders_not_invoiced_by_JM]![Text39]+(Sum([order_value)) but the result is #name.

Any ideas?
 
Elise,

I believe you have to add a reference to your main report. Something like this:
Code:
=[Reports]![YourMainReportName]![orders_not_invoiced_by_JM]![Text39]+(Sum([order_value))

Hoc nomen meum verum non est.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top