By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Calculating percentage from two subreports on a main report

P: 13
I have created a main report, which is controlled with a date range parameter from the main form. The report has several sub reports, which perform calculations (counts and averages at the subreport level) based on the date range from the main form. My question or problem is that I have to calculate a percentage based on the result of two of the subreports. I created a text box on the main report and I enterd the following to calculate the percentage on the control source:
=[Reports]![NewToSchedule]![Text7]/( Reports![NewToSchedule]![Text7]+Reports![NewToVoid]![Text11])*100
When I run the main report from the main form I get this #Name?
Could anyone tell me what I am doing wrong.

Thanks in advance
Oct 26 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
Make sure that when you are referencing the subreports, you are using the subreport control name, not the subreport name.

Check the Name property under the other tab in the properties window for the subreports
Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.