I'm trying to build a graphical report using a chart which show the costs of each project in our company, the cost is made up of employeeHours*wageRate and projectExpenses, the expenses are obtained from a subreport in my groupFooterSection and the hours from the summary details in my main report, I used variables to obtain the total cost from the subreport. I then added both costs together in a second groupFooterSection.
In my main report footer, I inserted a chart which graphs the costs on the x-axis and the project# on the y axis. The problem I'm having is that only the cost of employeeHours*wageRate is showing up on the x-axis, the projectExpenses from the subreport are not there, even though they're both added up correctly in the second groupFooterSection.
It's as if the chart in the main reports last footer can't consider values from a subreport, is this the case?