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:
Open Microsoft Excel.
Select Data
PivotTable and PivotChart Report.Select External Data Source and Pivot Table and then click Next.
Click the Get Data button.
Select the OLAP Cube tab, select New Data Source, and then click OK.
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 ...