Sub report syntax

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a main report rptpage2 which has a subreport rptpage3 which in turn
has a subreport rptsyndicatePage3. On this last report is a calculated
control I want to appear on the main report as well. My syntax is this
=[Reports]![rptpage2]![rptpage3]![rptsyndicatePage3]![Sum Of Sum Of
txtClientsaletot]
but I get the usual #Name error. I've looked at Help and I thought my syntax
was correct. Can anyone see what's wrong?
Thanks
Tony
 
Thanks Allen really useful.
Tony
Allen Browne said:
Tony, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

The article explains what expression to use, and how to troubleshoot it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Tony Williams said:
I have a main report rptpage2 which has a subreport rptpage3 which in turn
has a subreport rptsyndicatePage3. On this last report is a calculated
control I want to appear on the main report as well. My syntax is this
=[Reports]![rptpage2]![rptpage3]![rptsyndicatePage3]![Sum Of Sum Of
txtClientsaletot]
but I get the usual #Name error. I've looked at Help and I thought my
syntax was correct. Can anyone see what's wrong?
Thanks
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Summing totals from 2 subreports 1
Report with 2 Subreports 1
Calculate between SubReport and Report 1
Main Report Header is on SubReport 4
Calculate a sum of subreports in main report 1
Report with pivot tables and pivot charts in sub reports 6
Page numbers on sub reports? 2

Back
Top