Invoice Report written in Open Source (iReport or like) w MySQL Backend

Closed - This job posting has been filled and work has been completed.

Job Description

BACKGROUND: I am a small IT Service Provider. I have created my own PSA with a MySQL Database database with webfront end using Maestro PHP Generator and WP. This works seamlessly.

MY NEED: I need to have an invoice report created with "Open Source" software such as iReport Designer by Jaspersoft Reports . I do not need a report server but simply some way to generate the report and export as PDF or Excel. I have played around with iReport and been able to create some small reports but don't have the time to learn it or create professional looking invoice. If you know of a better Open Source solution we can talk about that as well.

INVOICE REPORT: My MySQL structure is as follows-

Tables: Invoices, Tickets, Labor, Expenses.
Relations: Invoices contain Tickets which contain Labor & Expenses.

The Invoice report will contain all Tickets linked to that invoice and the labor & expenses linked to those tickets along with a total.

The Invoice will look like:


Company Logo & Info

Client Info

Invoice # Invoice Description

Ticket # 1
Expense # 1 Description Amount (calculated)
Expense # 2 Description Amount (calculated)
Labor # 1 Description Amount (calculated)
Labor # 2 Description Amount (calculated)
Ticket # 2
Expense # 1 Description Amount (calculated)
Expense # 2 Description Amount (calculated)
Labor # 1 Description Amount (calculated)
Labor # 2 Description Amount (calculated)

TOTAL INVOICE AMOUNT XXX

The only parameter needed is "InvoiceName".