Thanks to all for the great content on this site - I've resolved a lot of issues by reviewing previous posts.
I've searched this forum pretty thoroughly and couldn't find the answer to the following:
I have a report that generates a document that replaces an older MS Word-based template. I've been able to replicate everything in the template except for the table of contents. I've found reference to a solution for populating a table of contents table based on the pages identified while printing the report (http://support.microsoft.com/?id=210269), but this requires that the table of contents report then be printed separately from the main report. I'm looking for a way to generate the content as a single document.
I can imagine two potential paths to investigate:
1. Somehow opening, print previewing all pages, and closing the report to populate the table of contents table, then opening the report again and not updating the table of contents.
2. generating the table of contents via some other mechanism (e.g., not basing it off data stored in a table).
Subreports, VBA, macros, and voodoo are fair game. Appreciate any help you can offer in advance.
Jim
I've searched this forum pretty thoroughly and couldn't find the answer to the following:
I have a report that generates a document that replaces an older MS Word-based template. I've been able to replicate everything in the template except for the table of contents. I've found reference to a solution for populating a table of contents table based on the pages identified while printing the report (http://support.microsoft.com/?id=210269), but this requires that the table of contents report then be printed separately from the main report. I'm looking for a way to generate the content as a single document.
I can imagine two potential paths to investigate:
1. Somehow opening, print previewing all pages, and closing the report to populate the table of contents table, then opening the report again and not updating the table of contents.
2. generating the table of contents via some other mechanism (e.g., not basing it off data stored in a table).
Subreports, VBA, macros, and voodoo are fair game. Appreciate any help you can offer in advance.
Jim
