table of contents concatinated to a report

[ghodges]

hello,
I have a very large report ( more than 1000 pages) with picture of about 7000 items it . The items are all seperated into categories( about 100 categories)

I have written a seperate report to generate a table of contents

both reports work well, but i am sick of joining the two pdf files( once the print out) . I would like to join them in the one report


I would like to concatinate ( join together)the two reports in the one report, the 1000 pages of data and the table of contents

preferable the TOC first and then the main report with pictures...but lets crawl before run....the report then the footer is good enough

The only way i can see to do this is to put a subreport into the report footer.....
The problem is they are unrelated reports and i cant get it to display anything except the page number of the last category by doing this

Is it possible to put a subreport in a report footer?

any ideas?

any help would be greatly appreciated......

ps using access 2003

 

[vbaInet]

This is what I would do. Put the subreport in the REPORT HEADER section and set it to Force New Page after section.

If you already have something in the Report Header section, you would need to move it to the first Group Header (if you have one), and in the Print event of this section set those controls to only become visible on the second page.

You would need to create your own Page of Pages. Hide it on the first page (i.e. in the Print event of the Page Footer section), and add one to Page and one to Pages, i.e.

="Page " & ([Page] + 1) & " of " & ([Pages] + 1)