September 9th, 2006

Sample reports that use the TFS reporting feature

Buck Hodges
Director of Engineering

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: ,

Author

Buck Hodges
Director of Engineering

Director of Engineering, Azure DevOps

0 comments