I want to create a single report so the pagination (header and footer
info would be consistent).... BUT, this report will be composed of a
series of small table-style reports, each accompanied by a pie chart.
My problem is that the client wants the pie charts NEXT to the tabular
report. So, I have a subreport on the left, which can be set to grow
or shring, and a pie chart on the right, which appears to be limited
to whatever size I make it.
Beneath each report will be a section of "free-form" comments
pertaining to the report.
The problem is that I have approximately 8 of these (with more to
come) and they all have to be created with consistent pagination. And
Access 2003, appears to have a limit of approximately 22 inches for
the detail section of a report. So, I start dropping subreports on my
big report, add the chart next to the report, and put the field below
the report for the comments... And about 6 reports into the creation
I hit the bottom of the 22 inch limit.......
SO, how to I create a set of reports that all print together, and have
consistent header and footer information?