Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Is there any good php reporting tool available to generate reports on mysql tables?

I want to generate different reports from database just like Crystal Reports in .Net.

user-image
Question added by Muhammad Majid Saleem , Senior PHP Developer / Project Manager , SwaamTech
Date Posted: 2013/04/29

If you are looking for a solution to compile and manage an unlimited number of MySQL database reports based on tables and/or queries then Smart Report Maker is the tool just for you.
It's a quick and easy PHP MySQL report generator that gives you the ability to prepare the reports that you need at the click of a button.

https://developers.google.com/chart/interactive/docs/reference

Ali Raza Syed
by Ali Raza Syed , Virtual Assistant (Online) , PIDC-LC

There are many open source reporting tools readily available for companies to deploy to their business users today.
Most of them, however, do not provide hard core corporate features such as multiple user support, integration with existing security mechanisms, ad hoc visual reporting tools, scheduling facilities, and the like.
but there are some tools which I used and like most are mentioned below.
I would personally recommend using JasperReports.
It is the world's most popular open source reporting engine.
It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.
JasperReports provides a tool called iReport to develop SQL-based reports and the JasperServer to make these reports available via webserver.
Scheduling report creation is possible as well.
The JaserperServer community edition is released under AGPL License.
The iReport community edition is released under GPL License.
So both open source.
You can learn more about this wonderful tool and download it from http://community.jaspersoft.com/project/jasperreports-library.
Some other famous open source reporting tools are Birt, Datavision and Jacob.
There's one more very beautiful tool is PIWIK (http://piwik.org), but this software is specifically good for Web Analytics and Analytical researches.
Hope these details will work for you.
:)

Shailesh Thanki
by Shailesh Thanki , Project Manager , Ak System Pvt. Ltd

Try something like this:

http://www.hkvstore.com/phpreportmaker/

 

There are lot of other tools are available as well but best is to code yourself. :)

 

 

You can use an open source Flowchart PHP library https://github.com/komola/Flowchart-renderer.
If you can provide Flow chart customization and mention nodes.
Thanks, Muhammad Raheel www.muhammadraheel.com

Muhammad Bilal Ahmed
by Muhammad Bilal Ahmed , Senior Front End Developer , Seven Software Development

you can try this : and give your opinion Crystal Reports can handle mySQL pretty nicely.
If you are looking for open-sourced than dmyreports might come handy.
http://sourceforge.net/projects/dmyreports/

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.