Free Guide to Creating, Modifying and Installing TFS Reports and Understanding the TFS Data Warehouse

Microsoft Downloads - Creating and Customizing TFS Reports

"This article provides an introduction to the important concepts and step by step instructions to Create and Customize Reports for Microsoft® Visual Studio® Team Foundation Server (TFS).

..."

Microsoft must have heard my cries of mental anguish and despair during my recent "Create a Team Foundation Server Report" quest and have provided this download as a map to future adventurers (lol... yeah, I've been reading too much fantasy recently, can you tell? ;)

If you creating or modifying TFS reports, or plan to, then you owe it to your brain cells and sanity to take a few minutes and check out this information...

 

The download includes 10 files, four PDF's, five sample reports (RDL) and a readme;

Creating and Customizing TFS Reports.PDF

34 page PDF introducing the TFS data warehouse, how to get started building a report, building a query/data source, and then actually creating a new Bug Rate (with parameters)

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

..."

How To Install a Report to TFS Project.PDF

10 page PDF covering how to manually install a TFS report on a Reporting Services server for a given TFS Project, hook up to the default, already existing data sources, etc

Bug Trends.PDF (Bug Trends.RDL)

Six page PDF providing a few details on the included Bug Trends report. How to use it, what it's all about and how to customize it.

Remaining Work.PDF (Remaining Work by Count.RDL, Remaining Work by Size.RDL)

Five page PDF providing a few details on the included Remaining Work reports. How to use them, what they are all about and how to customize them.

Status by Area.PDF (Status by Area.RDL)

Six page PDF providing a few details on the included Status by Area report. How to use it, what it's all about and how to customize it.

 

Related Past Post XRef:
Understanding the Team Foundation Server Data Warehouse
Sample TFS Reports