Can I export Word document(*.doc) from Reporting Service by using free component?

Question

I'm looking for some tool that can generate many document formats like Microsoft Excel, PDF, Microsoft Word, HTML. So, I decide to use Reporting Service of SQL Server 2008 Express. But I found that Reporting Service can't export to Microsoft Word by itself. It need to use some component. Moreover, I can't find any free component to doing this or It's impossible?

Thanks,

Answer 1

I'm not sure what you mean by "Reporting Service can't export to Microsoft Word by itself".

Reporting Services 2008 can export to all of the formats you mentioned (Excel, PDF, Word and HTML), it's one of its basic features. I've used this feature in both the express and full versions of SS2008.

See http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx

Answer 2

As already mentioned reporting services can already export in these formats, you can also specify on the url if you want to render the report in another format instead of as a webpage, like this:

http:///reportserver?/Sales/YearlySalesSummary**&rs:Format=HTML4.0&rs:Command=Render**

See - http://msdn.microsoft.com/en-us/library/ms154040.aspx

You can also get the reports to export in these formats if you are running the reports of a schedule

Answer 3

Aspose.Words for Reporting Services is not free, but will do a good job.