Average of Subreport Values

[esipp]

All right, I avoided the problems of fixed column counts in a cross-tab query report by putting each value in the detail field of my report in it's own subreport. (I have 12 months and sales amounts that may or may not have been reported--and I need the report to run regardless. The result is 12 sub-reports, one for each month).

The report output may look like this:

TenantID
Jan Feb Mar Apr.....
2002 100 100 150

2003 200 200 200 100

2004 100

2005 300 100

NOW, I would like to add an "AVERAGE" line to run in the TenantID footer to average the above values (if any). How do I reference the sub-reports when it's really only 1 subreport, 12 times (with different child/master field links)?

Please HELP!

 

[RobertScott]

wow

That is a lot of subreports, I did a report like this recently.
Every value under the month is retrieved through sub reports?

I don't know how complicated it is for you to get those values
but wouldn't it be easier in the long run to have one sub-report in
your details section that queries what you need for each month?
If that happens it would be A LOT easier to get the
average for each month.

Scott

 

[esipp]

How do I avoid the crosstab query problem where if one month has NO record, the whole report will not run (this is due to a fixed number of columns (12 for 12 months) but an empty crosstab dataset for one month).

That is a lot of subreports, I did a report like this recently.
Every value under the month is retrieved through sub reports?

I don't know how complicated it is for you to get those values
but wouldn't it be easier in the long run to have one sub-report in
your details section that queries what you need for each month?
If that happens it would be A LOT easier to get the
average for each month.

Scott