THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Richard Hundhausen: The DBAgilist

This is a mirror of Richard Hundhausen's (aka The DBAgilist) blog "Tales from the Doghouse."

September 2006 - Posts

  • Support for Word and Excel reporting from Reporting Services

    Reporting in Team System is handled by SQL Server 2005 Reporting Services. As such, team members get to enjoy (and are restricted-by) the built-in report rendering extensions (CSV, Excel, HTML, Image, MHTML, PDF, and XML). What's missing from this list is the Microsoft Word DOC format and a richer Microsoft Excel XLS format.

    This is where a product called OfficeWriter comes in. It enables you to use Excel or Word to create templates utilizing data markers and merge fields for databinding sections of the document to the various Team Foundation Server data items. After a quick configuration of Reporting Services, your reports can generate documents/spreadsheets based on these templates without the need for Microsoft Office on the server. There's also an integration with Reporting Services that will let you create these documents without any coding at all. Users will design their RDL reports using Excel or Word, without the need for Visual Studio or SQL Report Builder.

    Check out their latest version of OfficeWrite (v3.6) at http://officewriter.softartisans.com

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement