Reporting in Team Foundation Server 2010 – Part 1: Introduction
This is the first chapter in the series on Reporting in Team Foundation Server (TFS) 2010. In this series, I’ll cover the following topics:
- Walkthroughs for out-of-the-box experience including customizations
- Custom report authoring tools and walkthroughs
- An overview of the reporting architecture
Out-of-the-box, we have several ways to report on the data in TFS to analyze and track project progress, quality and various other metrics:
SharePoint Dashboards
- We have a brand new set of dashboards based on Microsoft Office SharePoint Server (MOSS)/SharePoint Server as well as Windows SharePoint Services (WSS)/SharePoint Foundation.
Rich SQL Reporting Services (SSRS/RS) Reports -
<table> <tbody> <tr class="odd"> <td><a href="https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_msdn/sunder/WindowsLiveWriter/ReportinginTeamFoundationServer2010Part1_ECA4/image_10.png"><img src="https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_msdn/sunder/WindowsLiveWriter/ReportinginTeamFoundationServer2010Part1_ECA4/image_thumb_4.png" title="image" alt="image" width="428" height="332" /></a></td> <td>We have a whole set of new and improved RS reports, about 16 RDL reports in the MSF for Agile 5.0 template and 15 RDL reports in the MSF for CMMI 5.0 template, providing visibility into bugs, builds, tests etc.</td> </tr> </tbody> </table>
Excel Reports from Work Item Queries -
<table> <tbody> <tr class="odd"> <td><a href="https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_msdn/sunder/WindowsLiveWriter/ReportinginTeamFoundationServer2010Part1_ECA4/image_12.png"><img src="https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_msdn/sunder/WindowsLiveWriter/ReportinginTeamFoundationServer2010Part1_ECA4/image_thumb_5.png" title="image" alt="image" width="428" height="322" /></a></td> <td>This is one of the features that lower the barrier to entry in building your own reports that I like to highlight; the ability to generate a report in Excel based on a work item query.</td> </tr> </tbody> </table>
I’ll cover each of these topics with detailed walkthroughs in the next few chapters. If you have questions or feedback please leave me a comment or send me an email at sunder.raman at microsoft.com