Table of Contents for 2 separate Reports

[cyanidem]

Ask if you get stuck

[pharrison74]

After doing some reading about subreports and trying it myself. I don't get what it will do for me. All it wants to do is add the report over top of my table of contents.

Read a few articles and they all have the same instructions.. Maybe I don't understand what they are for?

Pete

[cyanidem]

The idea is to include all 3 reports as subreports of one main "book". You may need to add page break after each subreport. All that will help with numbering pages of those 3 reports continuously. But at the same time you need to amend UpdateToc() function slightly to cover title and case name at the same time. And then rework ToC report as well but that should be piece of cake for you

[pharrison74]

"And then rework ToC report as well but that should be piece of cake for you ``

LMAO!! Ok will mess with it today and see what I can come up with. Got a meeting tomorrow on an update for where I am at. Will go from there..

Thanks
Peter

[cyanidem]

That honestly will be the easiest part, you'll have all data in a toc table, just need to prepare report from it, add proper sorting and grouping, easy peasy
Rebuilding UpdateToc function may be harder, so don't hesitate to ask if you have a problem with that

[pharrison74]

So I should use the Table of Contents report as the main and add the other 3? I was thinking of using report 1 when and adding the other two. Guess it makes sense your way as I would just be able to print the TOC and all the reports would print at the same time.

Oh well.. Will do my best.

[cyanidem]

Actually I was thinking about creating new empty report, adding those 3 as subreports on it, moving inittoc() reference to onopen event of main report, changing updatetoc() so it fills toc table with title and case name and then printing this main report and toc report after that. Mainly because you need to fill toc table before you print toc report. But may work if you set up main report with toc as subreport at the end of it

[pharrison74]

I get it till about the part where you are changing updatetoc then I am lost.

Argg was so hoping the other way would of worked Was so happy friday till I say the pg numbers on the reports themselves were wrong .
Thank god the other reports aren't as complicated.

[cyanidem]

Ok, have a look at this.
Testing_Litigation_DB1.zip
Print preview "Book Form 0 Main Report" - that's the main report containing all 3 subreports. Then print Toc report.

[pharrison74]

That works amazing ...Thank you so much. I see what you did with the reporting and the sub reports and it makes so much sense. As well I see the only code you changed was referencing the Book 0 report for page numbers.

I will do what you have done myself on my db so I actually know how to do it instead of just exporting it.


Again you ROCK!!!!!

[cyanidem]

I also removed all OnPage events code as it's not needed anymore and no need to calculate number of pages between reports