Sunday, February 19, 2012

Create Dynamic Table of Contents and Indexes

I was wondering if someone can tell me if there is a way to create a dynamic table of contents and index for a report that is run.

For example, I need to create a directory of physicians based on a search query of our database. So each report would contain a list of doctors and locations, but on each query of the report the doctors would show up on different pages of the report. I want to be able to create a table of contents and an index for the report that will list the page number the doctor first shows up on.

With MS Access VBA, I was able to do this by using the print event, in which I would add each record to the access database table which contains the table of contents, while the report was printing and therefore creating the table of contents.

Is there a way (similiar) with SQL RS that I can accomplish this task?

My reports have lots of pages, about 3-20 pages per report, so I too thought about including a table of contents.

Anyone found a solution yet?

No comments:

Post a Comment