Sample reports that use the TFS reporting feature


If you are interested in the TFS reporting feature, you may want to check out the sample reports in the zip file attached to the following blog post.

Sample Team System Reports

This attachment contains a variety of samples, experiments and untested reports for use with the Team Foundation Data warehouse. There is a brief overview document describing the reports and how to deploy them.

zip file: TFS Reporting Samples.zip

Here’s what you’ll find in the zip file.  If you have any questions or have feedback for the team, be sure to post in the MSDN TFS Reporting Forum.

C:msdownTFS+Reporting+Samples>tree /F
Folder PATH listing for volume IBM_PRELOAD
Volume serial number is 002B0067 18A4:2518
C:.
│   Installing the Sample Reports.doc

├───Box Reports
│   └───Box Reports
│       │   Box Reports.sln
│       │
│       └───Box Reports
│               Actual Quality vs Planned Velocity.rdl
│               Box Reports.rptproj
│               Box Reports.rptproj.user
│               Bug Rates.rdl
│               Bugs by Priority.rdl
│               Bugs Found Without Corresponding Tests.rdl
│               Builds.rdl
│               Issues and Blocked Work Items.rdl
│               Load Test Comparison.rdl
│               Load Test Detail.rdl
│               Load Test Summary.rdl
│               Load Tests.rdl
│               Project Velocity.rdl
│               Quality Indicators.rdl
│               Reactivations.rdl
│               Regressions.rdl
│               Related Work Items.rdl
│               Remaining Work.rdl
│               Requirement Details.rdl
│               Requirements Test History and Overview.rdl
│               Tests Failing without Active Bugs.rdl
│               Tests Passing with Active Bugs.rdl
│               TfsOlapReportDS.rds
│               TfsReportDS.rds
│               Triage.rdl
│               Unplanned Work.rdl
│               Work Item with Tasks.rdl
│               Work Item with TestResults.rdl
│               Work Items.rdl

├───Portal Reports
│   │   Portal Reports.sln
│   │
│   └───Portal Reports
│           Bug Rates.rdl
│           Copy of Quality Indicators.rdl
│           Issues and Blocked Work Items.rdl
│           Portal Reports.rptproj
│           Portal Reports.rptproj.user
│           Project Velocity.rdl
│           Quality Indicators.rdl
│           Reactivations.rdl
│           Remaining Work.rdl
│           TfsOlapReportDS.rds
│           TfsReportDS.rds
│           Triage.rdl
│           Unplanned Work.rdl

├───Sample Reports
│   │   Sample Reports.sln
│   │
│   └───Sample Reports
│           7 Day ZBB.rdl
│           Area Overview.rdl
│           Code Coverage.rdl
│           Files by Directory.rdl
│           Files by Person.rdl
│           Files by Priority.rdl
│           Files by Type.rdl
│           Issues and Risks.rdl
│           Project Schedule.rdl
│           Projection.rdl
│           Quality Indicators – Portal.rdl
│           Quality Indicators.rdl
│           Reactivations and Resolutions.rdl
│           Report Gallery.rdl
│           Sample Reports.rptproj
│           Sample Reports.rptproj.user
│           Source Code Details.rdl
│           Source Code Overview.rdl
│           Task Burndown.rdl
│           Test List.rdl
│           Tests by Category.rdl
│           TfsOlapReportDS.rds
│           TfsReportDS.rds
│           Work Item List – Point in Time.rdl
│           Work Item List.rdl
│           Work Item Revisions.rdl
│           Work Items.rdl

├───TFS Report Examples
│   │   TFS Report Examples.sln
│   │
│   └───TFS Report Examples
│           Related Work Items.rdl
│           Related Work Items.rdl.data
│           TFS Report Examples.rptproj
│           TFS Report Examples.rptproj.user
│           TfsOlapReportDS.rds
│           TfsReportDS.rds
│           Work Item Chart.rdl
│           Work Item Chart.rdl.data
│           Work Item List.rdl
│           Work Item List.rdl.data
│           Work Item Trend.rdl
│           Work Item Trend.rdl.data

├───Warehouse Status
│   │   Warehouse Status.sln
│   │   Warehouse Status.vssscc
│   │
│   └───Warehouse Status
│           Deployed Reports.rdl
│           Query Execution History.rdl
│           Query Execution History.rdl.data
│           Report Execution History.rdl
│           ReportServer.rds
│           TfsOlapReportDS.rds
│           TfsReportDS.rds
│           TfsTeambuild.rds
│           TfsTrace.rds
│           TFSVersionControl.rds
│           Warehouse Load Rates.rdl
│           Warehouse Status.rdl
│           Warehouse Status.rptproj
│           Warehouse Status.rptproj.user
│           Warehouse Status.rptproj.vspscc
│           Work Item Load Status.rdl
│           WorkItemTracking.rds

└───Work Item Overview
    │   Work Item Overview.sln
    │
    └───Work Item Overview
            TfsOlapReportDS.rds
            TfsReportDS.rds
            Work Item by Priority Detail.rdl
            Work Item by Priority.rdl
            Work Item List.rdl
            Work Item Overview.rdl
            Work Item Overview.rptproj
            Work Item Overview.rptproj.user

tags: ,

Comments (13)

  1. Johan Danforth on How to delete a TFS Build Type.

    Paul Cornell on Visual Studio 2005 SDK Documentation…

  2.   If you are always wishing for more reports and never seem to have the time to make them all then…

  3. Rob Caron says:

    Microsoft bloggers frequently blog their interest for receiving your feedback on ideas to improve our…

  4. Rob Caron says:

    Microsoft bloggers frequently blog their interest for receiving your feedback on ideas to improve our…

  5. El Bruno says:

    Great job !!!

    I’ll try the most interesting ones, and I’ll let you know my experience :D

    Bye from Spain

  6. El Bruno says:

    Buenas, Gracias a Buck Hodges , podemos descargar un archivo que contiene una serie de reportes que podemos

  7. El Bruno says:

    Buenas, Gracias a Buck Hodges , podemos descargar un archivo que contiene una serie de reportes que podemos

  8. Buck Hodges says:

    I don’t often post about reporting. My last post was about sample reports for TFS from a year ago. If

  9. I don't often post about reporting. My last post was about sample reports for TFS from a year ago

  10. Any chance of an update to these reports. I am having a lot of trouble getting them working under TFS2008 as the TfsDataWarehouseExtensions bit does not exist…

  11. Dylan says:

    Yes, I second that, is there a similar archive for TFS 2008?

  12. chandan says:

    I am getting error while downloading this zip file.

  13. buckh says:

    chandan, the attachment on the post that I link to still works, though the link I copied into my post no longer works. To be honest with you, I don't expect this to be of much value to you given that these were written for TFS 2005.