TEK Query ReportsTEK 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.
-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
Test TEK workitem
Visit us for more information