I have a TOC, manually created, which is currently a sub-report to my main report.
I've read the MS Knowledge Base instructions for creating an automatic TOC, and I'm thinking of trying them.
The instructions indicate that when you print or preview the report, the TOC is generated, and then you print the TOC separately to the main report. I'm wondering if I could set a code, which instead of directly printing the report would a) preview the report and therefore generate the TOC sub-report; then b) refresh the report, to update the TOC sub-report in the main report; then c) print. I'm thinking that to the end user this should just look like a printing function.
My other thought would be to have a separate code button that says "generate TOC", which previews, updates the sub-report, (which would update the main report). And then the actual printing is a separate command.
Any thoughts? Comments? Previous experience?
***EDIT***
Just working through these instructions the MSKB. Step 4 - "Create the following procedure". What does this mean? I've only ever written code by going through the event tab of the properties of an element. Where do I put this code?
***EDIT***
Frizzle frazzle. These instructions aren't going to work for me 'cause my 'headings' are labels. They're not fields in a table anywhere. My basic report layout is:
Label with heading
Subreport
repeated about 14 times.
Any further thoughts?
I've read the MS Knowledge Base instructions for creating an automatic TOC, and I'm thinking of trying them.
The instructions indicate that when you print or preview the report, the TOC is generated, and then you print the TOC separately to the main report. I'm wondering if I could set a code, which instead of directly printing the report would a) preview the report and therefore generate the TOC sub-report; then b) refresh the report, to update the TOC sub-report in the main report; then c) print. I'm thinking that to the end user this should just look like a printing function.
My other thought would be to have a separate code button that says "generate TOC", which previews, updates the sub-report, (which would update the main report). And then the actual printing is a separate command.
Any thoughts? Comments? Previous experience?
***EDIT***
Just working through these instructions the MSKB. Step 4 - "Create the following procedure". What does this mean? I've only ever written code by going through the event tab of the properties of an element. Where do I put this code?
***EDIT***
Frizzle frazzle. These instructions aren't going to work for me 'cause my 'headings' are labels. They're not fields in a table anywhere. My basic report layout is:Label with heading
Subreport
repeated about 14 times.
Any further thoughts?
Last edited:
