.Net 环境中的正确报告解决方案
我的网络应用程序有一个报告要求，我正在寻找现成的解决方案。 我没有任何报告软件的经验，因此考虑与 SO 社区核实是否有人有任何适合我的要求的报告解决方案的想法。
该应用程序将在.Net 中开发，除了其他功能之外，我还需要报告功能。 整个应用程序的外观和感觉应该看起来相同。
是否可以将报告软件嵌入到 .Net 应用程序中，或者需要单独的服务器实例？ 哪一个更好？
我需要从数据库中公开一些表，用户应该能够对此创建任何类型的查询（报告）。 用户应该能够保存查询并为其命名。
用户保存的查询应该只有他自己可见。 一个用户属于一个组。 用户可以创建一个对整个组都可见的报告（如果他选择这样做）。
我目前正在查看 izenda，看看它是否支持我的要求。
I have a reporting requirement in my web application for which I am looking for off the shelf solution. I don't have any experience of reporting softwares so thought of checking with SO community if anyone have any idea of reporting solution which fits my requirements.
The application will be developed in .Net and apart from other functionalities, I need reporting capability. The look and feel of the entire app should look same.
Is embedding a reporting software into a .Net application is possible or a separate server instance is required? Which one is better?
I need to expose few tables from my database and user should be able to create any kind of queries(report) on that. User should be able to save the queries and name them.
A query saved by a user should be only visible to him. A user belongs to a group. A User can create a report which is visible to whole group as well if he choose so.
I am currently looking at izenda to see if it supports my requirement.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我们一直在使用 LogiXml，它可能具有您需要的所有报告功能，但也没有嵌入很好。 我们能够通过他们的网关使用非常简单的 HTTP POST 身份验证将其与我们的产品集成，并通过直接与他们的数据库集成来同步用户和角色。
它值得一看，但我不记得在生产实例中运行它的许可费用是多少。
We've been using LogiXml, which probably has all the reporting features you need, but doesn't embed too nicely. We were able to integrate it with our product using very simple HTTP POST authentication through their gateway, and by integrating directly with their database to synchronize users and roles.
It's worth looking at, but I can't recall what the licensing fee is to run it in a production instance.
准备报告有两个方面。 一个是获取数据，另一个是渲染它们。 假设您只对渲染感兴趣，您可以查看 Microsoft 的 ReportViewer 组件，该组件在 Web 和桌面上均可用。 您可以在此处查看它
优点：它是免费的，具有所有标准功能（表格、颜色、子报告） 、交叉表）。 具有内置的 Visual Basic 脚本，可用于计算列的值，或根据值选择颜色。 它类似于 Excel 中内置的 Visual Basic
缺点：您只能在 Visual Studio 中或使用 MS-SQL 2005 中的工具设计报表。无法使用新的独立报表生成器，因为它不兼容，它会生成更新格式的 rdlc 文件。
还有更多内容，但我建议看一下。
There are two sides to preparing reports. One is getting your data and another is rendering them. Assuming you are interested in just rendering, you can look at Microsoft's ReportViewer component which is available both web and desktop. You cans look at it here
Pros: It's free, has all standard functionality (tables, colors, sub-reports, cross-tab). Has build-in visual basic script that can be used to calculate values of columns, or choose colors based on the values. It's similar to what Visual Basic built into Excel
Cons: You can design your reports only in Visual Studio or with tool from MS-SQL 2005. The new standalone Report Builder cannot be used, since it's not compatible, it produces rdlc files with newer format.
There are more into that, but I would suggest to take a look.
尝试 DevExpress XtraReports Suite。
Try DevExpress XtraReports Suite.
如果您需要基于 HTML 的 Web 报告编辑器，而不需要 Flash 等，Izenda Reports 是非常好的解决方案。 设置和使用非常简单。 但它不支持自定义报表设计。
Izenda Reports is very good solution if you need web-based report editor on HTML, without Flash or so on. It is very easy with setup and use. But it doesn't support custom report design.