Internal notes in statistics

[Odopt]

Hi!
I've been looking around for an answer to this question but with no luck.

I would like to create statistics/reports showing all activities containing time units/accounted time, not only summarized per ticket.
We are using free text fields to group tickets to projects/clients and would like to produce detailed information for billing reasons.

The report could look like this for one ticket (the list should just continue with other tickets):

Ticket# Title Type Text Accounted time Freetext1
2011062010000091 New XXX customer – email-external qwerqwerqwer 3 Project-1
2011062010000091 New XXX agent – note-internal asdfasdfasdfas 1 Project-1
2011062010000091 New XXX agent – note-internal tytyertyetyyer 3 Project-1
2011062010000091 New XXX agent – email-external ghkghkghkkgkh 3 Project-1

Is it possible to achieve this via the statistic module or should I aim directly on the data in the SQL?

Take care
/Magnus

[crythias]

Most statistical reporting is done from the tickets table. If you want ticket_history, you'll probably have better luck via api or select via sql.