I would have the following problem:
I am currently having 1 main report and 2 subreports. In both subreports a weekly sum of sales is calculated and grafically displayed via a chart. Both subreports use different db tables.
In subreport 1 the total amount of sales of product A is calculated on a weekly base.
In subreport 2 the total amount of sales of product B is calculated on a weekly base.
Now I would need the weekly sums of both sub reports within my main report in order to calculate the amount of total sales of product A + product B on a weekly base.
Unfortunately, I fail on doing that. I tried to add the weekly sub totals to a shared array in order to use it in my main report, but this causes me to have loads of variables within my main report.
Is there any way of accomplishing this in an easy way?
I hope I expressed my prolem as clearly as possible and I hope someone can help me.
Thanks a lot, cheers.