Report Design UI for PHP

Question

Report Design UI for PHP

Navigation

#1 by (3 votes)

3

I've used Crystal Reports a lot to visually create my reports based on queries in the database. It was very easy to group repeated information into the query.

I have searched for PHP software or libraries to do the same thing in web environment, ie reports on PHP pages searching from a MySQL database. I have not found anything that I can handle so efficiently. I need to manually do each report and work the loops, ifs, totals, etc.

Is there any software where I visually model my report, with its groupings etc, then generate HTML + PHP code for dynamic reports?

php mysql

asked by anonymous 03.09.2014 / 01:26

1 answer

Make my site appear in the Google news listing String Connection excel .xls .xlsx C #

score 3 · Accepted Answer

An interesting alternative is iReport which is a tool developed by the same company as JasperReports (heavily used in Java). There are at least two possible ways to use the reports generated in the iReport visual environment by php, by holding a Java server where php connects to Java through PHP / Java Bridge or using the PHPJasperXML class (in pure php). That way you use a specific reporting tool (I forgot to mention it's free), it generates a jrxml file (an xml) which is the report file. Then just use PHPJasperXML to interpret or use JasperReport via PHP / Java Bridge. On youtube you have several videos taught to use, I'll leave a link to a video teaching to do a basic report if I wanted to check a little more about iReport . I hope you have service to clarify your doubt. The complete tutorial on how to use it will pay off.