Calculating percentage from two subreports on a main report

josecruz

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

MMcCarthy

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