I'm looking for a way to create a summary report showing "spent time" and "amount". The problem I'm experiencing is that every request id with multiple time entries is shown on multiple rows i.e. if request id 1 has five time entries, request id 1 is shown five times, one row for each time entry.

What I'm looking for in the report is the possibility to have one row for each request id no matter how many time entries a request id has. The columns "time spent" and "amount" should hold the total amount for the request id.

Is this possible?

Kind regards

Mattias