UI for PHP report design

Asked

Viewed 3,066 times

3

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

I have been looking for software or PHP libraries to do the same thing in a web environment, that is, reports in PHP pages looking for a Mysql base. I couldn’t find anything that I could handle so efficiently. I need to keep manually doing every report and working on 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 report

  • Occasionally you have something http://alternativeto.net/software/crystal-reports/? Platform=online

  • @brasofilo, unfortunately none of the similar applications is possible. However I saw that Crystal Reports has a web version, I will search, but anyway it is a very expensive application. Thanks!

1 answer

3


An interesting alternative is the iReport which is a tool developed by the same company Jasperreports (much used in Java). There are at least two possible ways to use reports generated in the visual iReport environment by php by maintaining a Java server where php connects to Java through PHP/Java Bridge or using the Class Phpjasperxml (pure php). This way you use a specific tool to develop report (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 has several videos taught use, I will leave a link to a video teaching to do a basic report if you wanted to check out a little more about iReport. I hope you have service to clarify your question. The full tutorial on how to use I will be owed.

  • Thanks Sileno. It’s a spin I may have to give. I believe it’s still easier than creating HTML and Loops/calculations at hand in PHP.

Browser other questions tagged php mysql report

You are not signed in. Login or sign up in order to post.