Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS export to word

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2010-03-23 : 00:03:47
I would like suggestions(or modifications) on ways to architect the following:

Goal is to create a set of sql server reports 2008 that has a table of contents and is exported to word 2003 or word 2007.

1. I am going to have each sql server report 2008 as separate RDL files.
2. I am going to tie all the repoirts together in a C#.NET or Visual Basic.NET application by Building Reports from the Object Collection using ReportViewer.
3. I then need to create a table of contents that exports to word. To accomplish this task I am thinking of a. either using jquery so that I can add auto TOC generation, and/or b. write a .net embedded custom application on each report that will obtain the report name and page number from the report footer. The data will then written to a 'table of contents' sql server database that will be used to help generate the table of contents.

Let me know what your thoughts are and/or any modifications you may have.,

Thanks!

   

- Advertisement -