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