TFS Extensions Kit. TEK Query Reports

TEK Query Reports

TEK Query Reports creates reports in Microsoft Excel from a Work Item Query without need to have SQL Reporting Services.

Features & Benefits

Each report includes worksheets displaying a PivotTable and a PivotChart report that derives data from the Work Item Query and not from the SQL Server Analysis Services cube.

Ideal for:

-TFS Basic installations that do not have installed SQLSAS

-Restrict Microsoft Excel ad-hoc to avoid users to see work item reportable data they are not permitted!

It solves this question: http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/ceb2db18-6473-4734-8acb-206c5f70d6a4/#ceb2db18-6473-4734-8acb-206c5f70d6a4

Reports from a query displaying approx. 300 work items takes 12 seconds

How to use it

In Team Explorer, open a flat-list work item query that contains the work items that you want in your report.

In Select Report dialog, specify filter criteria
in Microsoft Excel click each worksheet tab to review each report

ezien