I'm attempting to automate a rather large report that my database needs to be able to produce.
I'm also attempting to adapt the "Table of Contents" functions from the Microsoft Knowledge Base, but can't work on it more until I get my current problem out of the way.
The report will be approximately 35 pages in length, populated with data from numerous tables and sources.
The task had previously been done manually from excel pivot-tables (copying them into word).
The basic structure of every page would be:
Page Header.
Section Header.
Some particular part of the report.
The TOC is being based on the section heading information, so the page header and section header aren't a problem to create.
However, since it is a different report on each page I'm having a few problems.
So far I've tried to:
Use an unbound sub-report in the detail section and set it's record-source during run-time, which I found out yesterday that you couldn't do or it would cause some weird errors,
And to put all of the reports into the one section and use the onPrint event to make visible only the one that I want to show.
Neither has seemed to work very well so far.
Does anyone have any ideas or alternate solutions to accomplish this?
I'm also attempting to adapt the "Table of Contents" functions from the Microsoft Knowledge Base, but can't work on it more until I get my current problem out of the way.
The report will be approximately 35 pages in length, populated with data from numerous tables and sources.
The task had previously been done manually from excel pivot-tables (copying them into word).
The basic structure of every page would be:
Page Header.
Section Header.
Some particular part of the report.
The TOC is being based on the section heading information, so the page header and section header aren't a problem to create.
However, since it is a different report on each page I'm having a few problems.
So far I've tried to:
Use an unbound sub-report in the detail section and set it's record-source during run-time, which I found out yesterday that you couldn't do or it would cause some weird errors,
And to put all of the reports into the one section and use the onPrint event to make visible only the one that I want to show.
Neither has seemed to work very well so far.
Does anyone have any ideas or alternate solutions to accomplish this?
