Calculated control on main report 1

[niteraven]

I have a main report named rptinvoicing.
rptinvoicing report has a subreport on it called subinvoice, subreport is based on a query.
In subinvoice i have in the report footer a calculated control, TotalSum (=sum([indcost] is the control source)
In the main report i am trying to reference the TotalSum control.
I have used the following references and get the #name? error:

=[Reports]![rptinvoicing]![subinvoice]![TotalSum]
==[Reports]![rptinvoicing]![subinvoice].[report]![TotalSum]=subinvoice!TotalSum

All give the same error. Is there something i am doing wrong?

Thanks
Raven

 

[Remou]

It should be:

=[Reports]![rptinvoicing]![subinvoice].Report![TotalSum]


This referes to forms, but a similar set of rules applies to reports:

http://www.mvps.org/access/forms/frm0031.htm

 

[niteraven]

Hi remou,

Thanks for your reply. I used the reference that you gave me in the main report and it still did not work. (#name error)There is data in the totalsum field on subreport.

I also made a new unbound control on the subreport in the report footer, the control source is =TotalSum and tried to reference that in the main report. THat didnt work either.

I printed the page that you sent link for and tried alot of those references using reports instead of forms and couldnt get it to work.

Any idea why none of these work?
Thanks
Raven

 

[Remou]

Have you tried using the Expression Builder? Sometimes names may not be quite as you think they are.

 

[niteraven]

Remou,

Thank you very much. that worked! I was referencing the name of subreport. when i used expression builder it used the labelname of the subreport. I have never encountered that before!

Have a star!

Thanks
Raven