MySQL 开源报告服务
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3582381/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL open source reporting services
提问by david99world
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.
我目前正在从事一个需要报告服务的项目。数据库后端是使用 MySQL 构建的，我想要一些具有类似功能的东西来说 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
大卫
采纳答案by O. Jones
When you say "reporting service" I suppose you mean "report programming and generating system." Is that right?
当您说“报告服务”时，我想您的意思是“报告编程和生成系统”。那正确吗？
Jasper - http://community.jaspersoft.com/
Crystal Reports, if you can deal with an non-open-source system.
Crystal Reports，如果您可以处理非开源系统。
These all work fine with MySQL.
这些都适用于 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.
不幸的是，所有这些报告系统都在进行一些荒谬的旋转，他们告诉自己他们是“商业智能解决方案”而不是报告编程方案。因此，您将通过营销 BS 进行一些挖掘，以找出简单问题的解决方案，例如“我如何按邮政编码列出微酿啤酒的销售情况”或您想报告的任何内容。
回答by Peter Green
For MySQL reporting you could try one of the following. Unfortunately none of them are open source.
对于 MySQL 报告，您可以尝试以下方法之一。不幸的是，它们都不是开源的。
MySQL Pivot table generator- recommended if you want to create analytical & summary reports
Navicat- very powerful
MySQL 数据透视表生成器- 如果您想创建分析和汇总报告，推荐使用
Navicat- 非常强大
