471,063 Members | 2,131 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,063 software developers and data experts.

Calculating percentage from two subreports on a main report

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
1 2322
14,534 Expert Mod 8TB
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.

Similar topics

1 post views Thread by Don Sealer | last post: by
6 posts views Thread by Brett Barry: Go Get Geek! | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.