O'Reilly logo

Professional Team Foundation Server by Mickey Gousset, Erik Gunvaldson, Jean-Luc David

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required