I have several large reports for which that I produce "Tables of Contents".
I have a table with two columns, description and pagenumber.
In the On_Open module I run a query that clears this table.
In the On_Format module of the group header, I add a line to this table, consisting of the group description and the pagenumber.
When the report completes, I run another report that uses this table to produce a "Table of Contents".
This works fine for two reports, but on the third I only get the items from the first page.
If I run the report in preview form, then click on the control to see the last page, and then run the table of contents report, it all works.
I even cut and pasted the code from a report that works fine, and this problem continues.
Any ideas on how to force a module to run for every page?
I have a table with two columns, description and pagenumber.
In the On_Open module I run a query that clears this table.
In the On_Format module of the group header, I add a line to this table, consisting of the group description and the pagenumber.
When the report completes, I run another report that uses this table to produce a "Table of Contents".
This works fine for two reports, but on the third I only get the items from the first page.
If I run the report in preview form, then click on the control to see the last page, and then run the table of contents report, it all works.
I even cut and pasted the code from a report that works fine, and this problem continues.
Any ideas on how to force a module to run for every page?
