We are using an application developed by our internal team from last 2 years. It is ERP like application. Now the data is increased to such extent that we can't figure out the analytics from data. So to make the reports and analytics which is the best PHP Reporting Tool.

I have tried Jasper Reports but it is best for JAVA.

My data is stored in MySQL And my application is in CakePHP.

  • 2
    You have to give us more details, so that we can help you. What kind of database is the data stored in? Why do you want the reporting tool to be in PHP? Even if your ERP is in PHP, your reporting tool could be in Java. By the way, what kind of reporting would you like to do? (give us a few examples). Thanks, and welcome to Software Recommendations! :-) – Nicolas Raoul Apr 25 '14 at 2:30
  • 2
    The reporting tool would probably connect to MySQL directly, without caring about the PHP code. Is it OK? Do you want the reports and analytics to be done from within the ERP application maybe? (harder to do, requires development) – Nicolas Raoul Apr 25 '14 at 5:31
  • 1
    I personally love Pentaho and Jasper. It is hard to tell which one would be the best for you, because the question does not mention many requirements... Actually the question really becomes "What is the best reporting tool that can read from an ERP's custom MySQL tables and generate reports/analytics?" ... which is quite a broad question. Let me think a bit. – Nicolas Raoul Apr 25 '14 at 5:42
  • 2
    By the way, is Open Source a requirement? – Nicolas Raoul Apr 25 '14 at 5:48
  • 1
    Yes I need open source only. – عثمان غني Apr 25 '14 at 6:10

You can use Jasper Reports on PHP using this implementation of Jasper Report on PHP, it's quite good, but i think is not 100% compatible, anyway you get most of the features of Jasper Report natively on PHP.


Try Pentaho Community, it's a very good product for Business Analysis. The community edition contains the Report Designer module that can connect to any input source (Text file, CSV file, DB Server, Sqlite, etc etc) through the Data Integration module.


I'm currently looking myself but have found a fairly extensive list.
Most I am ignoring because they seem to be relatively old or under powered but here are a few more that haven't been mentioned previously:

Hope that helps (btw, I'm leaning toward Reportico or Pentaho Community... depending on which one is easier to setup).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.