Product Company Support Purchase Blog Reviews
   
  Download Eval Now
divider
 
OfficeWriter Blogs
 

How to open a report from SQL Server Reporting Services with the Application object

Submitted by alisonb on Wed, 05/08/2013 - 14:05

Problem

You want to modify your reports with the WordApplication or ExcelApplication object after they've been populated with data by SQL Server Reporting Services. The ExcelApplication or WordApplication object's Open method can't pull a report from a report server, so how do you open a SSRS report with OfficeWriter?
 

OfficeWriter and Excel Services: When to Use Which

Submitted by chrisb on Sun, 09/25/2011 - 16:32

Current and potential customers often ask our sales team: "what is the difference between OfficeWriter and Excel Services?" The high level answer is that that they are very different products designed to address very distinct scenarios. In brief, OfficeWriter is a tool that developers can use to generate, read, and manipulate Excel and Word documents in .NET code. Excel Services is a SharePoint-based server product for sharing, managing, and securing Excel workbooks.
 

Exporting SQL Server Database Data to Excel

Submitted by chrisb on Fri, 09/23/2011 - 16:05

Introduction

The need to get business data from a SQL Server database (or any other kind of RDBMS for that matter) into Excel for further analysis is universal. I would venture to say that anyone in any business role from marketer to analyst to salesperson to executive to program manager has had the occasion to say: "I need this data in Excel so that I can crunch it!"
footer
Follow SoftArtisans on Facebook! Follow SoftArtisans OfficeWriteron Twitter! Follow SoftArtisans on LinkedIn! Follow SoftArtisans Blogs! Follow SoftArtisans on YouTube! Follow Us on Google Plus! Have a Question? Go to StackOverflow!
divider
Copyright 2023 © SoftArtisans All Rights Reserved.
 +1.617.607.8800 | PO Box 590684, Newton, MA 02459 USA| E: contact@softartisans.com | Contact Us