I am new to Jasper. I have been trying to embed jasperserver in my zend php project with Mysql database. But till now I couldn't find a way to execute SQL queries via my app on Jasperserver. The PHP jasper libraries which I am using (both Rest and SOAP) is not showing me how to generate reports based on my query. So I am in a dilema that whether I should go with Jasperserver Java platform and use a php-java bridge to embed it OR can I manage querying with PHP itself?.. Any help is appreciated.....
Please refer below links may be useful to you
If you are seeking the possibility to create reports from SQL queries 'on the go' — sorry, but this is not what JRS can do. To create reports you need a tool to author jrxml files: Jaspersoft Studio or iReport. Professional version of JRS also has Ad Hoc Editor, where one can create simple table, chart and crosstab views from domains and topics. But the point of JasperReports Server is to serve as a repository for already created reports, generate them on specified schedules, and provide access control.
The furthest that JRS API can do is creating a ReportUnit resource with required dependencies and running its export as html/pdf/rtf/etc. But for that you need to have your jrxml file prepared.
With regards to PHP clients, the next big thing is https://github.com/Jaspersoft/jrs-rest-php-client. It is still in development and testing, but it's a new client that uses the new (v2) JRS REST API.