Using SoftArtisans OfficeWriter with SQL Server Reporting Services 2005
page 1 of 10
Published: 23 Aug 2006
Unedited - Community Contributed
Abstract
This article provides an overview of how SoftArtisans OfficeWriter interacts with SQL Server Reporting Services 2005 in a step-by-step manner and what it has to offer above and beyond standard SSRS functionality.
by Mike Campbell
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 55448/ 107

Introduction

Microsoft's SQL Server Reporting Services (SSRS) is revolutionizing the way organizations use data.  Prior to the arrival of SSRS, most reporting solutions were either costly or technically complex.  This typically kept reporting out of the reach of small to medium sized businesses that were not able to afford custom "in house" solutions or high-priced services and analysts to pour over their mountains of data and render it intelligently.  However, SSRS is changing all of that by putting a dependable reporting platform easily within reach of small to medium sized businesses that allows them to access powerful reporting functionality without spending a fortune or making them wait on long development cycles.

Larger businesses and enterprises can also benefit from SSRS and its extensible architecture.  SSRS offers an open Web Services interface which allows larger companies (with dedicated resources) to create custom Data Processing, Delivery, and Rendering extensions to meet their own particular needs.  This open architecture also allows 3rd parties to offer software products and services to help address recurring customer needs - generating an entire market of SSRS add-ins and extensions.

As an example of meeting market demand, well-known ISV SoftArtisans supports customized SSRS design and rendering extensions in their highly acclaimed OfficeWriter product.  With these extensions, businesses can create native Microsoft Excel and Microsoft Word reports with SQL Server Reporting Services.  And, unlike the out of the box rendering extensions provided by SSRS that output static "copies" of SSRS reports into Word and Excel, reports generated by OfficeWriter enjoy full "native" functionality including formatting, formulas, macros, data-bound charts, and a host of other goodies.  It is therefore no wonder that this extension has met with great success even garnering a finalist position for Best Business Intelligence Product at the 5th Annual Best of Tech Ed in Boston of 2006.


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






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


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-03-30 10:35:41 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search