June 18, 2007 10:06 PM
by Ed Blankenship
So, if you didn't know I'm a huge fan of the Quality Indicators report in the MSF for Agile Software Development process template in Team Foundation Server. Here at Infragistics, we're evaluating the Conchango Scrum Process Template for Team System and I don't get that wonderful report I love :-( I've been stalling (because I haven't ever written a SQL Reporting Services custom report for TFS) but I finally did it today. It really wasn't that bad. Thank God I already had most of the report set up for me! There are a TON of data and metrics you can get from the OLAP cube in the TFS Data Warehouse.
If you haven't read the Wrox Professional Team Foundation Server book, then it's a great avenue for learning TFS. It also has a good section on how to creating custom reports with the Visual Studio Report Designer.
Really the only issue with just importing the original report to the Scrum team project is the fact that Bugs are actually Sprint Backlog Items with an Item Type of Bug (as opposed to the MSF Agile template that just has a separate bug work item type) and the status of an active bug is actually "In Progress."
Really, you can use this method to port this great report into just about any process template you might be using. Pretty much any of the OLAP metrics can be changed.
What other kinds of reports should we have? Do you have any interesting custom reports that you find useful for the major process templates that are available on the Internets and what not?
UPDATE: I've attached a modified report if you don't want to go through all the steps of customizing. Just download it and start at Step 6. It's much more fun doing it yourself though!
P.S. We're changing up some of our tags to better organize all of our blog posts. May take some time...
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u
Ed Blankenship is a Product Manager at Microsoft for Visual Studio Online. I am an author of a few books, former Microsoft MVP of the Year, and former ALM consultant.
Managed Windows Shared Hosting by OrcsWeb
Site design by Jeremy Kratz