I've been looking at them previously, but honestly haven't tried any of them as my company at the time decided to go for a commercial (expensive) alternative.
Reporting Services Report Builder for SQL is about the simplest. You do have to provide a model of your data for it but that would be necessary for users who dont understand the data structures anyway (sounds like you have that sort of user).
这是 SQL Server 的 BI 工具与 Excel 如此完美集成的原因之一 - 他们做了一些研究，发现用户倾向于恢复使用 Excel，因为每个人都知道如何使用并且知道如何使 Excel 输出看起来完全一样他们希望如此。
话虽如此，您可能需要考虑一些基于 Excel 的报告解决方案或与 Excel 集成的工具。
Palo 是免费的，类似于 Cognos TM1（很花钱！）将允许用户在 Excel 中创建报告。它还具有非常类似于 Excel 的 Web 界面。
I hate to say it, but the one thing you'll find users doing even if you get a reporting tool is that they'll move their data to Excel for final output.
This is one of the reasons why SQL Server's BI tools integrate so nicely with Excel - they did some studies that found users have a tendency to revert to Excel, since everyone knows how to use and and knows how to make Excel output look exactly the way they want it to.
Having said this, you might want to consider some Excel based reporting solutions, or tools that integrate with Excel.
Palo, which is free, is similar to Cognos TM1 (spendy!) and will let users create reports in Excel. It also has a very Excel-like web interface.
If they're that technically unsavvy, you'll also need to make sure the database presents useful entities. If they have to assemble their own Orders, for instance, they're not likely to be successful no matter how simple the tool is.
I've seen the "you can write your own reports!" thing blow up several times.
Perhaps you can try Quick Reporting Tool. It is simple and easy to use. The SQL scripts created from its Developer Module can be directly executed by user in the End-User Module without any screen design or programming skill needed.
发布评论
评论（11）
我认为两个最著名的开源替代方案是：
我以前一直在关注它们，但老实说还没有尝试过其中任何一个，因为我的公司当时决定去做一个商业广告（昂贵的） 选择。
I think the two most well known open source alternatives are:
I've been looking at them previously, but honestly haven't tried any of them as my company at the time decided to go for a commercial (expensive) alternative.
你的要求非常不具体。您正在寻找一个简单的工具。您是指临时报告工具，例如 i-净清晰报告？
Your requirements are very unspecific. You are searching a simple tool. Do you mean an ad-hoc reporting tool such as i-net Clear Reports?
Pentaho 报告（来自 Pentaho BI Suite）可能值得一看。
Pentaho reporting (from the Community edition of the Pentaho BI Suite) might be worth a look.
Reporting Services SQL 报表生成器是最简单的。
您确实必须为其提供数据模型，但这对于不了解数据结构的用户来说是必要的（听起来您有这类用户）。
RS 也随 SQL Server 一起免费提供。
Reporting Services Report Builder for SQL is about the simplest.
You do have to provide a model of your data for it but that would be necessary for users who dont understand the data structures anyway (sounds like you have that sort of user).
RS comes free with SQL Server too.
我不想这么说，但即使您获得了报告工具，您也会发现用户所做的一件事是他们会将数据移动到 Excel 中以进行最终输出。
这是 SQL Server 的 BI 工具与 Excel 如此完美集成的原因之一 - 他们做了一些研究，发现用户倾向于恢复使用 Excel，因为每个人都知道如何使用并且知道如何使 Excel 输出看起来完全一样他们希望如此。
话虽如此，您可能需要考虑一些基于 Excel 的报告解决方案或与 Excel 集成的工具。
Palo 是免费的，类似于 Cognos TM1（很花钱！）将允许用户在 Excel 中创建报告。它还具有非常类似于 Excel 的 Web 界面。
I hate to say it, but the one thing you'll find users doing even if you get a reporting tool is that they'll move their data to Excel for final output.
This is one of the reasons why SQL Server's BI tools integrate so nicely with Excel - they did some studies that found users have a tendency to revert to Excel, since everyone knows how to use and and knows how to make Excel output look exactly the way they want it to.
Having said this, you might want to consider some Excel based reporting solutions, or tools that integrate with Excel.
Palo, which is free, is similar to Cognos TM1 (spendy!) and will let users create reports in Excel. It also has a very Excel-like web interface.
您可以通过SBOeCube，这是SAP Business One的商业智能报告工具。
You can go through SBOeCube, this is a Business Intelligence Reporting Tool for SAP Business One.
这对你有用吗？
http://www.hkvstore.com/phpreportmaker/
当然，您可以随时开始自己的。
will this work for you?
http://www.hkvstore.com/phpreportmaker/
and of course you can always start your own.
如果他们在技术上不那么精通，您还需要确保数据库提供有用的实体。例如，如果他们必须组装自己的订单，那么无论工具多么简单，他们都不太可能成功。
我看过“你可以自己写报告！”事情爆炸了好几次。
If they're that technically unsavvy, you'll also need to make sure the database presents useful entities. If they have to assemble their own Orders, for instance, they're not likely to be successful no matter how simple the tool is.
I've seen the "you can write your own reports!" thing blow up several times.
我邀请您尝试 DBxtra。
www.dbxtra.com
I invite you to try DBxtra.
www.dbxtra.com
QlikView 是新兴的报告工具之一
http://www.qlikview.com/
QlikView is one of the emerging reporting tool
http://www.qlikview.com/
也许您可以尝试一下快速报告工具。它简单易用。用户可以在最终用户模块中直接执行从其开发人员模块创建的 SQL 脚本，无需任何屏幕设计或编程技能。
在线演示：
快速报告工具演示
网站：
www.little-creations.net
Perhaps you can try Quick Reporting Tool. It is simple and easy to use. The SQL scripts created from its Developer Module can be directly executed by user in the End-User Module without any screen design or programming skill needed.
Online demo:
Quick Reporting Tool Demo
WebSite:
www.little-creations.net