Technician Report

Hi there,

I have Technicians assigned to Requests, Technicians assigned to Request Tasks, and Technicians assigned to Project Tasks.

I'm looking for a report that shows all assignments of a technician.

The columns should be:
Technician
Module (Request/Milestone etc)
Request ID (blanks if not approriate)
Project ID (blanks if not approriate)
Task ID (blanks if not approriate)
Scheduled Start Time
Scheduled End Time
Project End Time
Estimated Effort - Days
Estimated Effort - Hours
Requester (blanks if not approriate)

Can you help please?

We use MySQL.

Many thanks.

Gary