TFS Burn down charts

Question

I want to create a simple ssrs report showing rolling burndown chart for each team member in a particular iteration/sprint. So if 5 members are on the team then there should a burndown chart for each of the member depiciting the remaining effort (in hrs) against last 30 days. This will be a rolling time period from present date to last 30 days.

So, for team member A the burndown chart will have on Y-axis Effort remaining (in hrs) and on X-axix 30 dates.

Please suggest how can this be done. Thanks.

Answer 1

Are you using one of the standard process templates (e.g. MSF Agile)? If so, there is probably an existing report that's close to what you want, either built into the system or posted on the web. For example, here's a large collection of sample reports. (note: built for the 2005 version of MSF -- will require some tweaks for 2008)

If not, you'll have to make do with some more generic SSRS guidance, or edit your question to include the relevant pieces of your work item definition XML.

• P&P: Creating and Customizing TFS Reports
• MSDN: Using Excel for TFS Reporting
• MSDN: Reporting Services tutorials
• Blog: resources for TFS report developers