In part 1 of our series we went over the premise of using Team Foundation Server (TFS) and Crystal Reports to create reports for Agile Projects.  This included the basics of how the agile process can work.  Part 1 included some basics of how the agile project might work. That article went over how to utilize standard Team Foundation Server process templates with your agile process, to help produce reports to help manage your projects.

In the 2nd part of the series, we covered 2 reports: A Story details report to allow you to print out your stories to post up in your war room and a current iteration report to report the status of your current iteration, and a breakdown report. 

In the 3rd part of this series, we will explain how to create a burndown chart utilizing TFS and Crystal Reports.  We will explain the Burndown chart report, then delve into how we create that report, first looking at the SQL to run against the TFS database, then how to create the Crystal Report.