Z
ZigZagZak
I have a report that shows sales activity for the month. I have it set up so
that it shows all the sales numbers for each individual work day of the month
and then in the report footer section calculates daily average, projected
months total, and average order size from those numbers. Problem is, I need
to also show the previous months daily average projected total..... & same
month last year. So I tried putting a invisible subreport in the detail
section that gets the data from last month and one for last year. This
works, but the only way it retrieves the totals from the running sums is if
that subreport is Visible. I can't have it visible, any thoughts?
that it shows all the sales numbers for each individual work day of the month
and then in the report footer section calculates daily average, projected
months total, and average order size from those numbers. Problem is, I need
to also show the previous months daily average projected total..... & same
month last year. So I tried putting a invisible subreport in the detail
section that gets the data from last month and one for last year. This
works, but the only way it retrieves the totals from the running sums is if
that subreport is Visible. I can't have it visible, any thoughts?