O'Reilly logo

Reporting in TFS by Dipti Chhatrapati

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Excel reports

Creating Excel reports using work item queries is one of the easiest ways to generate custom reports. Excel reports via a work item query let you generate status and trend graphs. Once the reports are generated, data can be manipulated by adding or filtering the fields using a PivotTable.

Creating Excel reports using a flat query list

The following diagram shows the item count per member generated by a flat query list:

Creating Excel reports using a flat query list

The following are the steps to generate Excel reports using a flat query list:

  1. Open the flat query list, in Team Explorer in Visual Studio, that contains the items to be reported. For example, the All Tasks shared ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required