Using SoftArtisans OfficeWriter with SQL Server Reporting Services 2005
page 4 of 10
by Mike Campbell
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 38729/ 86

Seeing it in Action

With all of the theory and background out of the way, it is time to delve into some hands-on development to see OfficeWriter in action.  To follow along with the ensuing tutorial, you will need an existing instance of SQL Server Reporting Services and the ability to install the trial version of OfficeWriter available from the SoftArtisans site.  I would also highly recommend that you use either VMware Server or Microsoft's Virtual PC as a way to create a suitable working environment for any testing you would like to do.  These virtualizations solutions are all 100% free products so there is no reason not to use virtualization for testing purposes.

When you install OfficeWriter on your reporting server, it will add three new rendering extension DLLs to your Reporting Server's \bin\ directory and will modify its web.config to enable these DLLs as specialized rendering handlers.  Once you have completed installation of the server product, you will also be prompted to install the OfficeWriter Designer which you will need to do on a machine that has both access to your Reporting Server and is currently running Microsoft Office 2000 or better.

View Entire Article

User Comments

Title: RA   
Name: SA
Date: 2008-04-24 12:05:05 PM
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

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?

Title: RE: Dynamic Rendering (@giovanni)   
Name: Michael K. Campbell
Date: 2006-08-31 8:37:50 PM
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: (but you'll need to do wire-ups for code-behind/partial classing etc...)

Title: Render Dynamic   
Name: GIovanni Rivas
Date: 2006-08-31 6:06:35 PM
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 that could work like this. thx
if you can reply at

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-03-01 2:39:05 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search