We need to have a custom MySQL report designed that will work with our WHMCS billing system. We need the report to show the Operators name on the left and the # of closed tickets in their name closed within the month by then.
For instance… My name is Larry and let’s say in the month of February, I closed 20 tickets, and Bob closed 10 tickets for that month, then I want to display it like this:
Operator # of Tickets
Then, for each month, I want to be able to run this report and find out how many tickets each operator has closed out for a particular month.
I will spend up to $20 for this report.
Regards, Larry Braziel Whitewater IT