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

Viewing the Sample Report

Open a browser and navigate to your reporting server (e.g., http://localhost/reports/).  Once there, navigate to the folder where you instructed the Report Wizard to place your finished report and locate the Report1 report.  Once you click on the link, you will be greeted by a dialog requesting a parameter for you.  Select a location and then click View Report just as you have done in the designer.  After a few seconds of churning, your report will be rendered.  

Once it is rendered, try opening it up in Excel.  To do this, specify the Excel option from the Select a format drop down as indicated in Figure 4.

Figure 4

Once you have selected the Excel export format, click on the Export link and Reporting Services will provide you with an available download containing the results of your report.  Save the report and then open it once it finishes downloading or just open it directly if you would prefer.  Once opened, you can see that SSRS has done a great job of outputting your report to this Excel document.  It has even preserved some of the formatting (such as color).

Figure 5

While the data you wanted to output has been accurately rendered, if you had placed any charts or graphs into your Reporting Services Report, they would have been outputted to the Excel file as static images not as data-bound graphs.  Likewise, if you need to add any conditional formatting or other formulas to your report you are free do to so; you will just have to do it again each time you output the report.  What would be nice would be a way to make formatting changes and preserve them for future export operations.  Happily, with a sample report now created, you are ready to see what OfficeWriter can bring to the table.


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-07-12 11:01:14 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search