TFS Timesheet Reporting

Nov 25, 2009 at 11:59 AM

Are there any guides to reporting on the [historical] timesheet values entered against a work item.

We are currently using the Timesheet system to great effect, however-

The end result has been to create a new view in the TfsWarehouse [Crossing Over to the TfsTimesheet DB] and use Excel to PivotTable the results

Rows grouped by User->Area->Iteration->WI

Columns Grouped By Date

This gives almost an app in its own right, with the filters built in to Excel 07 it is currently the most flexible solution.