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