Using SoftArtisans OfficeWriter with SQL Server Reporting Services 2005: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Using SoftArtisans OfficeWriter with SQL Server Reporting Services 2005

page 10 of 10

by Mike Campbell
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 38584/ 58

Article Contents:

Summary

While we just modified a single report in this sample, the possibility exists to modify multiple reports and output them all in a single spreadsheet. In fact, without even modifying a single report, many end users would love to see a simple web app that would let them aggregate a number of Excel reports for export into a single spreadsheet. Providing them with such an option would be trivial using Reporting Services' SOAP interface coupled with OfficeWriter's ability to stream the contents of reports into new Work Sheets. With functionality like this, it is no wonder that OfficeWriter is gaining critical acclaim for its ability to extend and improve upon the existing success of SQL Server Reporting Services.

« (Page 9)

View Entire Article

User Comments

Title: RA
Name: SA
Date: 2008-04-24 12:05:05 PM
Comment:
Can Office writer help in renaming the sheet names once the report is exported from Report server

Title: Dynamic Rendering
Name: ST
Date: 2007-10-01 6:14:24 AM
Comment:
Hi,

I have tested the code given on the above. During the render, I get this exception "Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response." on the function Render(...). What am I missing on here?

Thanks.

Title: RE: Dynamic Rendering (@giovanni)
Name: Michael K. Campbell
Date: 2006-08-31 8:37:50 PM
Comment:
Giovanni, glad you liked the article.

Make sure you've got the SoftArtisans SAXW6NET.dll copied in to your /bin/ directory - that will likely be your biggest issue.

I also generated a VB.NET conversion of the default.aspx.cs page, and posted it up in my uploads section:
http://authors.aspalliance.com/mcampbell/Default_aspx_vb.zip (but you'll need to do wire-ups for code-behind/partial classing etc...)

Cheers.

Title: Render Dynamic
Name: GIovanni Rivas
Date: 2006-08-31 6:06:35 PM
Comment:
Hi, thx for the article, but i tryed to copy the code in cs that you give here and doesn't work, i have to so all the references to the Interop libary for excel and the methodthat you are calling there with the arguments doesn't exist. am i missing something, do you havea code in Vb.net that could work like this. thx
if you can reply at garf50@hotmail.com