Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Reporting in TFS
  • Table Of Contents Toc
Reporting in TFS

Reporting in TFS

By : Dipti Chhatrapati
4 (1)
Buy this Book
close
close
Reporting in TFS

Reporting in TFS

4 (1)
By: Dipti Chhatrapati
Buy this Book

Overview of this book

This book is intended for developers, testers, architects, and project managers who want to explore and make use of the reporting facilities of Team Foundation Server 2013. Although no previous experience of reporting is required, a basic understanding of the Team Foundation Components and project templates would be a plus.
Table of Contents (7 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Team Foundation Server Primer
Icon
1. Team Foundation Server Primer
Icon
Chapter objectives
Icon
TFS basics
Icon
ALM and TFS 2013
Icon
The TFS 2013 architecture
Icon
TFS and reporting
Icon
Summary
2
2. Work Item Querying
Icon
2. Work Item Querying
Icon
Team project scenario
Icon
Work item queries
Icon
Search box queries
Icon
Flat queries
Icon
Direct link queries
Icon
Tree queries
Icon
Summary
3
3. Excel Reporting
chevron up
Icon
3. Excel Reporting
Icon
Prerequisites to access Excel reports
Icon
Creating Excel reports
Icon
Excel Project Management reports
Icon
Bug Backlog Management Excel reports
Icon
Build Management Excel reports
Icon
Test Management Excel reports
Icon
Summary
4
4. SQL Server Reporting
Icon
4. SQL Server Reporting
Icon
SQL Server Reporting Services
Icon
SQL Server reporting tools
Icon
Understanding default SQL reports
Icon
Creating custom SQL reports
Icon
Summary
5
5. Team Web Access Reporting
Icon
5. Team Web Access Reporting
Icon
Granting an access level to a user or a group of users
Icon
Team web access standard reports
Icon
Summary
6
Index
Icon
Index

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 query considers all work items to have the task type as displayed in the following screenshot:
    Creating Excel reports using a flat query list
  2. Create a report in Microsoft Excel from the query results view:
    Creating Excel reports using a flat query list
  3. Select the desired details for the report to be generated.
    Creating Excel reports using a flat query list
  4. Click on Finish and wait until Excel completes the report generation process.
  5. As a result, Excel reports, in which every worksheet...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Reporting in TFS
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon