How can I display reports (SQL Server's Rep. Services) on Word?

[Lorenzo Jimenez]

Hi and thank for readling.

Our company is looking on the MS SQL Server 2005 and Reporting Services
tecnology. We found out that analysis and reporting is available from Excel
using the Add-in for SQL Server Analysis Services.

Is there an add-in that displays reports from Report Server on a Word
document?
Sometimes we need to display a chart or a small report.

Thanks very much,
Regards,

Lorenzo Jimenez

 

[Cindy M -WordMVP-]

Hi Lorenzo,

Our company is looking on the MS SQL Server 2005 and Reporting Services
tecnology. We found out that analysis and reporting is available from Excel
using the Add-in for SQL Server Analysis Services.

Is there an add-in that displays reports from Report Server on a Word
document?
Sometimes we need to display a chart or a small report.

No, nothing of this nature for Word, I'm afraid...

You'd need some code (VB, .NET, Delphi, possibly Word VBA) in between SQL and
Word to generate such documents.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Lorenzo Jimenez]

Thanks.
Regards,
Lorenzo

Hi Lorenzo,

No, nothing of this nature for Word, I'm afraid...

You'd need some code (VB, .NET, Delphi, possibly Word VBA) in between SQL and
Word to generate such documents.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[rbedick]

Hi and thank for readling.

Our company is looking on the MS SQL Server 2005 and Reporting Services
tecnology. We found out that analysis and reporting is available from Excel
using the Add-in for SQL Server Analysis Services.

Is there an add-in that displays reports from Report Server on a Word
document?
Sometimes we need to display a chart or a small report.

Thanks very much,
Regards,

Lorenzo Jimenez

A fast and dirty way to export SQL Server 2005 query results to a table
in a Word document is to use QueryToDoc (http://www.schematodoc.com).