sql server reporting services: Rendering reports to Word format -- sql server reporting services

Rendering reports to Word format

SuzyM
7/18/2006 5:11:02 PM

sql server reporting services:

Currently my company inserts graphs from Excel into a Word document. They
then update the Word document with explanations about their analysis.
The requirement is for the graphs in this Word document to come from
Reporting Services 2000. Analysts then need to be able to update the text in
the document.

The SoftArtisans product appears to provide the required functionality,
however, my company has very strict guidelines about introducing additional
software into the organisation.

Do you have any ideas about how to render the Word document, including
graphs and sub-reports using Reporting Services 2000?

Re: Rendering reports to Word format

Tim Dot NoSpam
7/19/2006 9:35:24 AM

I understand your dilemma, but I strongly suggest you attempt to leverage
commercial software that already does the job before trying to roll your
own.

If you have no other choice, get your hands on Office 2003 Interop
Assemblies. You can then render the report(s) through web service calls
(take a look at the Render() method). There are other methods that allow
you to get a list of the image streams for the report. You'll need to get
to the image streams and pull the chart image from the web service. Then
you can write the image(s) to the word document. This is one way to do it.

-Tim

[quoted text, click to view]