Create a Report

We have a custom built php site. We require two simple reports to be built: 1) Client Sales Reports by Jobs: A report showing our Sales per client, showing total number of jobs and (pre-tax) gross revenue. When clicking on the client name, it will take the user to Report#2 below. 2)Client Transaction Report: Basically a historical listing of a client's transactions (jobs). Each transacation will link to the client's invoice page, and will also include several action buttons, such as email, print and download There must be an option on this report to produce a Statement (which is a document listing all the transaction displayed) with the option to include copies of all invoices Both reports must be able to export in PDF, and CSV format