How DO I Generate a Table Of Contents For a Report?

Hi!!!

Can anybody help me with the generation of Table of Contents for a report using SQL Server 2005 Reporting Services. Let me ellaborate. The scenerio is...i m having a report of lets say 500 pages grouped on employees, showing the performance of each employee between specific date range. Now if the manager prints the report of 500 pages he will be more intersted to jump directly to a perticular employee's page which means my printed report had to have a Table of Contents on my grouped criteria (which in this case is employee number). I would really appriciate if someone can suggest me a solution for this.

Any reason why all 500 pages have to be printed? If your manager can agree to viewing the information on line, your best option would be to use a document map. Not sure if you can print the information used to build the document map but I'm guessing your table of contents would at least begin with a document map. BTW, document map properties are an attribute of a group.|||Yes actually i had that option of Document Map in mind but the thing is, there are scenerios where lenghty reports are printed and taken to meetings with every person having its own copy of report and they have to discuss those reports along with directly taking notes/comments on the printed report for future reference. So its a sort of compulsion to have TOC with page number reference for printed reports so that they can quickly jump to any specific page for discussion. I appriciate your reply but do you have any ideas to get it done by any means may be through coding or any other way?|||

Anybody? Its really urgent.

Thanx.

|||There should be some simple work around for this thing if it does not have a built-in support for it? any ideas guys?|||

I have been working on this table of content thing for a week now. I have somehow found a solution for that. You can write an assembly containing a function which would take 2 paramenters the page number and your group name (Which needs to be on the table of contents) and write them to an xml file or a database table. Once you are done with the assembly you can reference that assembly in you rdl file and pass that the page number and the current group on the page to that function. You will have a complete table of contents in form of an xml or database table whatever you select. If you have any questions i can explain them in more details

I have done this so far and now only thing left is to display that TOC on the original report again. I m wroking on it... so far this is what i tried... i added my TOC data set to a new report and made my original report a sub report in that report. Now there are 2 issues. (1) The sub report wont show the page numbers. (2) I will have to run the subreport once before the main report so that it writes the TOC values to the xml file or table which can be accessed then in the main report. I think it can be done on windows form or a web form to call that subreport as an independent report somehow hidden from user, but i would be more interested to do all this stuff from the report if possible.

Thanx!