office working with sql server report

C

classyjaz

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 .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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top