We would like someone to write a report taking a fed from our mysql database.
The db contains telesales phone info (eg extension , start of call , end of call , number called etc).
We would like to produce a graphical report that shows per extension , total time of outgoing calls and number of calls per hour.
eg it will show for extension 123 , that the sales person was made 10min of out going calls and 3 calls between 9-10am , then the next graphical bar will be 10-11am etc etc .Then on page 2 it will show the next extension etc etc
Time covered will be 0800 - 1800.
We need to be able to select a day and the report populates with the data.
If I run it at 10am it will show only 0900-10 with data but future time slots empty.
We are running Windows 2003.