I have used the Jazz Report Builder to produce a report of the "Planned Time" and the "Actual Time" spent on some work items. The SQL statement for this uses the "RIDW.VW_REQUEST T1" and then the "T1.ACTUAL_WORK" and "T1.PLANNED_WORK" attributes.

What I really want to report on is a breakdown of the time spent on each TIMECODE.

i.e. the values that are entered on a Work Item's "Time Tracking" tab, such as "Documentation", "Coding" etc.

Does anyone know how I can edit my SQL statement to get this information ?

Thanks