How to: Create custom reports for Team Foundation Server
Here's something that I didn't know that you could do, but should have assumed it: You can actually build custom reports for/about your Development Team (managed in Team Foundation Server) with SQL Server Reporting Services. I mean it is a SQL Server database, although how it stores the data is a bit different, but Microsoft supplies an abstraction layer to make it easier for ya.
Here's an overview of the "How To" article:
If you’ve used Microsoft® Visual Studio® Team Foundation Server (TFS), you may have seen reports that you would like to customize. I recently volunteered to revise some of the standard reports for the Microsoft Solutions Framework (MSF) team at Microsoft, and I have to admit that I didn’t realize what I had signed up for. It quickly became apparent that I’d volunteered for more than I was expecting. Working with reports can be very intimidating because it uses different technologies that you may not be familiar with. This article provides an introduction to the important concepts you’ll need to learn a “minimal path” through the technologies.
Reporting in TFS is built on top of Microsoft SQL Server Reporting Services and Microsoft SQL Server Analysis Services. You’ll also need some additional tools on top of Visual Studio, such as Business Intelligence Development Studio.
Here's the link to the article: Click here
~ Robert Shelton