• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Comparing results from subreports

I have a report that has two subreports on it.  I need to divide the totals from one subreport by the totals from the other subreport on the main report.  How is this done?
0
AaronGreene1906
Asked:
AaronGreene1906
1 Solution
 
jjafferrCommented:
assuming your sum1 is from Subreport1, and sum2 is from Subreport2,
make an unbound textbox in the Report call it sum12, where the Control Source of it should be:
=Reports![Report Name]![SubReport1 Name]![sum1] / Reports![Report Name]![SubReport2 Name]![sum2]


jaffer
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now