Menu
I am currently working on a project where reporting services are required. The database back end is built using MySQL and I would like to have something with similar functionality to say SSRS.
Does anyone have any experience with an open source solution for this? Any they would particularly recommend? It would have to be accessed via a browser.
Thanks,
David
359
MySQL Shell enables you to set up and run reports to display live information from a MySQL server, such as status and performance information. MySQL Shell's reporting facility supports both built-in reports and user-defined reports. The reporting facility is available from MySQL Shell 8.0. 16.
It comes as a free version with SQL Server. Data appears from the relational database, XML files, Excel, and other multidimensional data sources.
The meaning of the term has since changed and broadened, and it is now commonly used to describe forms of innovative publishing of online journalism, rather than the sourcing of news stories by a professional journalist.
MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).
When you say "reporting service" I suppose you mean "report programming and generating system." Is that right?
Jasper - http://community.jaspersoft.com/
BIRT - http://www.eclipse.org/birt/phoenix/
Crystal Reports, if you can deal with an non-open-source system.
These all work fine with MySQL.
Unfortunately all these reporting systems are engaged in some ridiculous spin where they're telling themselves they are "business intelligence solutions" rather than report programming schemes. So, you'll do some digging through the marketing BS to find out solutions to simple problems like "how do I list sales of microbrew beer by zip code" or whatever you want to report about.
54
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
