hey guys! You have helped me so much in the past I need one more request! On this complex report that I have been working on, I have the total number of hours calculated at the bottom of the report by a formula. Now, the powers to be again want a chart on the bottom of the report. Easy enough I though, but of course the chart wants to pull data from a table or query, and the calculation that I need on the chart on only performed on the report. Is there a way around this?
To quickly fill you in on how the total hours are pulled, there is a field called Project_complexity which returns a 1,2,3 or 4. Those numbers are calculated to determine the total number of hours per project. A runningSum is captured for each week on the report and shown at the end of the report.
If I try to put the formulas in the chart, it comes back as nothing. Any suggestions?
Thanks!
![[morning]](/data/assets/smilies/morning.gif "[morning] [morning]")
To quickly fill you in on how the total hours are pulled, there is a field called Project_complexity which returns a 1,2,3 or 4. Those numbers are calculated to determine the total number of hours per project. A runningSum is captured for each week on the report and shown at the end of the report.
If I try to put the formulas in the chart, it comes back as nothing. Any suggestions?
Thanks!
