Skip to Main Content
Professional Team Foundation Server
book

Professional Team Foundation Server

by Jean-Luc David, Erik Gunvaldson, Mickey Gousset
November 2006
Intermediate to advanced content levelIntermediate to advanced
521 pages
14h 16m
English
Wrox
Content preview from Professional Team Foundation Server

16.3. Creating Custom Team System Reports

The default project types in Team System provide a nice, consistent view into the development lifecycle. More often than not, you'll need other types of reports to supplement your project. For example, you may want visibility.

NOTE

SQL Server 2005 Enterprise provides better field names for your reports than other versions of SQL Server. For example, a field in SQL Server 2005 Standard may be represented as "WorkItem.WorkItem." In SQL Server 2005 Enterprise, it is represented as simply "WorkItem."

16.3.1. Mining Project Data Using an Excel Pivot Table Report

You can view your project data using an Excel pivot table. One of the key advantages of using a pivot table is simplicity; Microsoft Excel mines the data warehouse directly and has the built-in capability to display rich graphs and charts. Here is how you can set up Excel to view your project data:

  1. Open Microsoft Excel.

  2. Select DataPivotTable and PivotChart Report.

  3. Select External Data Source and Pivot Table and then click Next.

  4. Click the Get Data button.

  5. Select the OLAP Cube tab, select New Data Source, and then click OK.

  6. Write a custom name for your data source. (If you are unsure, write in something like TFSDATA.) To use pivot tables, you need to first download the OLEDB 9.0 drivers. If you want to install the drivers without having to install all the SQL client tools, refer to the package ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional Visual Studio® 2008

Professional Visual Studio® 2008

Nick Randolph, David Gardner

Publisher Resources

ISBN: 9780471919308Purchase book