为非程序员撰写报告?
我们希望用户能够在我们的应用程序中编写自己的报告。
它是一个网络应用程序。我们不在乎他们是否必须下载应用程序才能创建报告,但我们需要他们能够以 PDF 格式或类似格式从网络打印报告。
报告编写器供非程序员使用,或者最多是非常轻量级的程序员(例如制作 VBA 宏等的程序员)。 (虽然编写器不是该程序的核心部分。所以如果有学习曲线,那么在某种程度上这是可以接受的)
我们正在查看 Crystal Reports,但看起来它要花费 7000 美元,这太贵了现在就这么多(尽管我们的系统非常灵活,因此最终可以支持它)。我们还在研究快速报告,它看起来很有前途,但我不确定报告编写者是否容易让非程序员掌握。
有人可以为非程序员推荐一个好的报告编写者,而且不会花很多钱吗?
we are wanting for users to be able to write their own reports in our application.
It is a web application. We don't care if they must download an application in order to create reports, but we need for them to be able to print off reports from the web in PDF format or similar.
The report writer is to be used by non-programmers, or at best very light programmers(like the ones that make VBA macros and such). (the writer is not a core part of the program though. So if there is a learning curve, then that is acceptable to a certain extent)
We were looking at Crystal Reports but it seems like it'll cost $7000 which is just way too much for right now(though our system is very flexible so could support it eventually). We are also looking at Fast Reports which seems pretty promising, but I'm not sure the report writer would be easy for non-programmers to grasp.
Can someone recommend a good report writer for non programmers that won't break the bank?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(6)
撰写报告不适合胆小的人。如果您有非程序员高级用户需要自己进行报告,那么最好的选择通常是公开数据并让他们使用 MS Access、InfoPath 或 Excel(或等效工具)等最终用户工具报告数据。
通过这种方式,您的应用程序可以为他们公开数据,让您可以控制他们可以访问数据的哪些部分(并防止他们意外写入数据),同时让他们使用针对非程序员需求而优化的工具。
只需很少的工作,您就可以通过 Office 工具包的 Web 服务轻松地与 MS Office 集成。
无论从编程的角度还是从用户培训/支持的角度来看,这都是迄今为止最简单的。
Report writing is not for the faint of heart. If you have non-programmer power users that need to do their own reporting the best bet is usually to expose the data and let them report on the data using end-user tools like MS Access, InfoPath, or Excel (or equivalents).
This way your application can expose the data for them, putting you in control over what parts of the data they can get to (and prevent them from accidentally writing to it) while letting them use tools that are optimized for the needs of non-programmers.
With very little work you can easily integrate with MS Office via web services via the Office Toolkit.
This is by far the simplest both from a programming standpoint as well as from a user training/support angle.
Telerik 报告是一个不错的选择,提供大量导出选项,需要一些简单的编程能力:
http: //www.telerik.com/products/reporting.aspx
Telerik reporting is a good choice and offers lots of Export options, will require some light programming ability:
http://www.telerik.com/products/reporting.aspx
MS SQL 报告服务器有一个组件 - 报告生成器,允许业务用户在不深入了解 SQL 等的情况下构建他们的临时报告。
我推荐版本 MS SQL Standard Edition 2008
MS SQL Reporting server has a component - Reporting Builder that allows business users to builds their ad-hoc reports without deep knowledge of SQL etc.
I would recommend version MS SQL Standard Edition 2008
QlikView 是我用过的最好的报告工具。数据深入分析令人惊叹。如果您正在寻找更便宜的东西(开源),Eclipse BIRT 也是不错的选择。 BIRT 有一个独立的工具,以及与 Eclipse IDE 的集成。
QlikView is the best reporting tool I've ever used. The data drill down is amazing. Also Eclipse BIRT is good if you're looking for something less expensive (open source). BIRT has a standalone tool, as well as integration with Eclipse IDE.
我们最终使用了 FlexCel.Net。 http://www.tmssoftware.com/site/flexcelnet.asp
(也许?)对于非程序员来说很容易使用,它也可以在目前优先考虑的 Mono 上运行。您可以在 Excel 中编辑报告模板,它确实非常强大。
We have ended up using FlexCel.Net. http://www.tmssoftware.com/site/flexcelnet.asp
Along with being (maybe?) easy enough for non-programmers to use, it also runs on Mono which is a high priority at the moment. You edit the report templates in Excel, and it really is quite powerful.
如果您仍在寻找此类工具,我可以建议您 EasyQuery.NET WebForms (http ://devtools.korzh.com/query-builder-net-asp/)
它更像是查询生成器而不是报告生成器,但也可用于生成简单的表格报告。
If you are still looking for such kind of tool I can suggest you EasyQuery.NET WebForms (http://devtools.korzh.com/query-builder-net-asp/)
It is more query builder than report generator but can be used to generate simple table reports as well.