report generator

Hello - I need to run a report that calculates total calls closed by technician and shows the following information:

Fields = Call ID : Call Description : Call Resolution : Open date : Closed date

Grouped by Technician

Date Range = not required, needs to be run since database started.

Totals = need a sub total for each technician and a grand total for all calls.

I have looked through your list of reports and none of them allow you to see the call and resolution data, so I think I need to run a query report. Could someone please let me know what I need to type in please to get the above result.

Have been playing around with Crystal, but whenever I include the resolution field, the totals suddenly reduce! There must be a problem with the table relationships; have looked through the forums, but there is no full relationship diagram (only partial). Perhaps this could passed to the users????

ANy help great appreciated, as I need to get this report done asap.

Cheers

Pedros

Thanks

PEter