Reporting in Team Foundation Server 2010 - Part 6: Rich SQL Reporting Services Reports

I started this series with a set of topics and broke the first one down into sub topics to cover the out-of-the-box experience in detail. With my last post, I covered the dashboards portion of the experience. Let’s look at the new SQL Reporting Services (SSRS/RS) reports written in Report Definition Language (RDL).

• Walkthroughs for out-of-the-box experience including customizations
  • SharePoint Dashboards
    • SharePoint Server dashboard
      • Out-of-the-box experience
      • Customizing the dashboard
      • Creating a team dashboard
    • Windows SharePoint Services/SharePoint Foundation dashboard
  • Rich SQL Reporting Services Reports
  • Excel Reports from Work Item Queries
• Custom report authoring tools and walkthroughs
• An overview of the reporting architecture

In TFS 2010, we are shipping 16 new SSRS reports in the Agile template and 15 new SSRS reports in CMMI template. First thing you’ll notice coming from TFS 2005/2008 is that we have report folders to organize these reports. Let’s start with the Stories Overview report under Project Management. Stories Overview is a great report where I can see work progress on user stories in context with test results and bugs.

A few sections to note on the new report format:

• The report description at the top outlines the purpose of the report
• There are links to other related reports on the right for other reports in this category
• We have baked questions each of these reports helps answer right into the report. This is one of the key pieces of information customers have asked for in the past.
• Parameter values used for generating the report which is useful if you want to print the report
• And, finally, we include the data updated timestamp to indicate the “freshness” of the data in the report

Let’s look at one more example, the Test Plan Progress report under Tests folder where I can look at the test plan progress over time. In this example, I see that we are not doing so well and have a good chunk of test cases that were never run. Over time, I want the green to go up in this report showing me that more test cases are passing.

These just a few examples showcasing the rich new reports we have shipping out-of-the-box in TFS 2010. Take a look at the other reports as well to see the insights we provide into your project.

In the next post I’ll cover one of the cool and handy new features for generating a report in Excel based on a work item query. If you have questions or feedback please leave me a comment or send me an email at sunder.raman at microsoft.com