Jasperstarter with different query in each report

Question

i'm trying to figure out if this is possible using JasperStarter and PHP

I want to create invoices, and they offcourse need to differ depending on what is being rented.

So for example i need to do an mySQL query like this:

SELECT thingBeingRented, price FROM invoices WHERE id LIKE $invoiceId

in my jrxml file before i compile and process it every time.

But is there anyway to pass the $invoiceId variable to the jrxml file?

I created the jrxml file using Jasper Studio.

Regards, Johan

Answer 1

Maybe this could help? https://github.com/cossou/JasperPHP ......