Skip to Content
Former Member
Jul 08, 2010 at 04:17 PM

Passing Multiple Values From Subreport to Main Report


Here is my dilemma. I have a main report that I am using to calculate total appointments by week. I am using a built in running total to sum up the count. Inside the Group, I have a subreport that calculates total doctor hours by week. Both of these reports work fine. However, what I need to do is pass back all of the doctors hours totals by week (24 weeks) back to the main report so I can perform additional calculations. Once I have the data in the main report, I need to be able to divide Total Appointments / Total Hours for each week. From this, I need to be able to graph it on a bar chart. How can I accomplish this? I tried fooling around with arrays but I was unable to have any success. Is there another way to pass multiple values from a subreport to a main report? Thanks.