Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Muhammad Majid Saleem , Senior PHP Developer / Project Manager , SwaamTech
Date de publication: 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
par 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
par 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
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?