If you have Microsoft SQL Server as Database, so you don't need to purchase License for support of SQL Reporting Services, but there is an issue with SQL Reporting Services, SQL Reporting services only Compatible with IE. check these links ... http://msdn.microsoft.com/en-us/library/ms156511.aspx
You can try jsreport. It’s free, open sourced, has .net client, cross platform (nodejs), does not require any compilation and it’s safe to let your users to modify their reports. Reports are designed using javascript templating engines that should give you maximum flexibility for your report layout.
CONS
does not currently support excel and word
in preview
does not talk directly with sql db, but you should anyway send data from your BL unless you are searching for BI reporting
You can try it without any authentication in jsreport playground
Reporting Services is the one I am most familiar with and it is the one most tightly ingrained in SQL Server, which is something that I prefer. I also happen to like the "feel" of RS a lot more than Crystal.
The other two options I am not familiar on at all, and I imagine they have a much smaller market share (and therefore much smaller community when it comes to finding help) than RS or Crystal.
One suggestion would be for you to do at least some evaluation of all these options. The primary reason would be so that you could learn just enough about them to judge how to keep them playing well together.
That way, if you either need to switch reporting engines, or perhaps to use a different engine for some particular requirements, you'll know how to do that.
SQL Reporting Services. They have a web tool to build ad-hoc reports that is as good as any other.
The general problem with ad hoc reporting is that the "thing" the user is trying to do is either beyond the tool or beyond the user and you have to do it any ways, and as a programmer SSRS is a better environment.
First off, thank you for the up-front mention of Windward. It's nice to see we're on the default short list :)
It really depends on what report desing approach works best for you. If you prefer a programming type approach inside an IDE, then it's Crystal, SSRS, etc. If you prefer an approach where you can design the reports in Microsoft Word, Excel, or PowerPoint (which IMHO makes report design and editing fast & easy), then take a close look at Windward Reports. (Disclaimer, I'm the CTO at Windward.)
For general information, I suggest dotnet-reports and reporting-software. The key to a system that works well for you is one where the design tool is a natural fit for your style - so try several.
ActiveReports、XtraReports、Telerik 都有很好的产品，并且都在积极改进（当然，速度不同）。 每个都有一个 Web 查看器，但它们不包含您可能希望从 Web 报告服务器获得的其余内容。
如果您确实需要 Crystal、ActiveReports、XtraReports 或 Telerik 报告（或任何其他报告设计器）的企业级 Web 服务器选项，现在可以从 www.versareports.com 获得。
I've worked with all the major reporting tools and each has their plusses and minuses. About the only "plus" on SQL Report Services side is that there's no additional $$ expenditure above the SQL Server license. The downside is that the report designer is probably the most child-like of all.
Crystal has been around forever, some love it, many hate it, it does the job, but has a serious price tag involved if you want to use it for anything other than personal use. And the web reporting server for it is VERY expensive.
ActiveReports, XtraReports, Telerik all have good products and all are being actively improved (at different speeds, of course). Each has a web viewer, but they don't include the rest of the things you might want from a web reporting server.
And if you find you really want an enterprise-class web server option for Crystal, ActiveReports, XtraReports or Telerik reporting (or any other report designer, for that matter), that's now available from www.versareports.com.
发布评论
评论（9）
如果您有 Microsoft SQL Server 作为数据库，那么您不需要购买 SQL Reporting Services 支持的许可证，但 SQL Reporting Services 存在问题，SQL Reporting Services 仅与 IE 兼容。 检查这些链接...
http://msdn.microsoft.com/en-us/library/ms156511。 aspx
SQL 报告服务 - 打印按钮未显示在Mozilla
另一方面，如果您使用 Reporting Services 以外的其他服务，则需要购买许可证。
If you have Microsoft SQL Server as Database, so you don't need to purchase License for support of SQL Reporting Services, but there is an issue with SQL Reporting Services, SQL Reporting services only Compatible with IE. check these links ...
http://msdn.microsoft.com/en-us/library/ms156511.aspx
SQL Reporting Services - Print Button not shown in Mozilla
On the other hand, If you use other than Reporting Services, You need to purchase License.
您可以尝试 jsreport。 它是免费的，开源的，有.net客户端，跨平台（nodejs），不需要任何编译，并且可以安全地让您的用户修改他们的报告。 报告是使用 JavaScript 模板引擎设计的，可以为您的报告布局提供最大的灵活性。
CONS
您正在搜索 BI 报告
您可以在 jsreport 中尝试，无需任何身份验证 playground
You can try jsreport. It’s free, open sourced, has .net client, cross platform (nodejs), does not require any compilation and it’s safe to let your users to modify their reports. Reports are designed using javascript templating engines that should give you maximum flexibility for your report layout.
CONS
you are searching for BI reporting
You can try it without any authentication in jsreport playground
Reporting Services 是我最熟悉的服务，也是 SQL Server 中根深蒂固的服务，这是我更喜欢的服务。 与 Crystal 相比，我也恰好更喜欢 RS 的“感觉”。
另外两个选项我根本不熟悉，我想它们的市场份额比 RS 或 Crystal 小得多（因此在寻求帮助时社区也小得多）。
Reporting Services is the one I am most familiar with and it is the one most tightly ingrained in SQL Server, which is something that I prefer. I also happen to like the "feel" of RS a lot more than Crystal.
The other two options I am not familiar on at all, and I imagine they have a much smaller market share (and therefore much smaller community when it comes to finding help) than RS or Crystal.
一项建议是您至少对所有这些选项进行一些评估。 主要原因是这样你就可以对它们有足够的了解，以判断如何让它们一起良好地合作。
这样，如果您需要切换报告引擎，或者可能需要使用不同的引擎来满足某些特定要求，您就会知道如何做到这一点。
One suggestion would be for you to do at least some evaluation of all these options. The primary reason would be so that you could learn just enough about them to judge how to keep them playing well together.
That way, if you either need to switch reporting engines, or perhaps to use a different engine for some particular requirements, you'll know how to do that.
SQL 报告服务。 他们有一个网络工具来构建与其他报告一样好的临时报告。
临时报告的普遍问题是，用户试图做的“事情”要么超出了工具，要么超出了用户，你必须以任何方式去做，而作为程序员，SSRS 是一个更好的环境。
SQL Reporting Services. They have a web tool to build ad-hoc reports that is as good as any other.
The general problem with ad hoc reporting is that the "thing" the user is trying to do is either beyond the tool or beyond the user and you have to do it any ways, and as a programmer SSRS is a better environment.
首先，感谢您预先提到 Windward。 很高兴看到我们进入默认的候选名单:)
这实际上取决于哪种报告设计方法最适合您。 如果您更喜欢 IDE 内的编程类型方法，那么它是 Crystal、SSRS 等。如果您更喜欢可以在 Microsoft Word、Excel 或 PowerPoint 中设计报告的方法（恕我直言，这使报告设计和编辑变得快速且轻松） ），然后仔细查看Windward Reports。 （免责声明，我是 Windward 的 CTO。）
对于一般信息，我建议 dotnet-reports 和 < a href="http://www.reportingsoftware.info/" rel="nofollow noreferrer">报告软件。 一个适合您的系统的关键是设计工具自然适合您的风格 - 因此请尝试多个。
First off, thank you for the up-front mention of Windward. It's nice to see we're on the default short list :)
It really depends on what report desing approach works best for you. If you prefer a programming type approach inside an IDE, then it's Crystal, SSRS, etc. If you prefer an approach where you can design the reports in Microsoft Word, Excel, or PowerPoint (which IMHO makes report design and editing fast & easy), then take a close look at Windward Reports. (Disclaimer, I'm the CTO at Windward.)
For general information, I suggest dotnet-reports and reporting-software. The key to a system that works well for you is one where the design tool is a natural fit for your style - so try several.
Crystal Report可轻松与.net集成
Crystal Report which can be easily integrated with .net
我使用过所有主要的报告工具，每种工具都有其优点和缺点。 SQL Report Services 方面唯一的“优点”是，除了 SQL Server 许可证之外，没有额外的美元支出。 缺点是报表设计者可能是最孩子气的。
水晶一直存在，有些人喜欢它，很多人讨厌它，它能完成工作，但如果您想将它用于个人用途以外的任何用途，则需要付出高昂的价格。 而且它的网络报告服务器非常昂贵。
ActiveReports、XtraReports、Telerik 都有很好的产品，并且都在积极改进（当然，速度不同）。 每个都有一个 Web 查看器，但它们不包含您可能希望从 Web 报告服务器获得的其余内容。
如果您确实需要 Crystal、ActiveReports、XtraReports 或 Telerik 报告（或任何其他报告设计器）的企业级 Web 服务器选项，现在可以从 www.versareports.com 获得。
I've worked with all the major reporting tools and each has their plusses and minuses. About the only "plus" on SQL Report Services side is that there's no additional $$ expenditure above the SQL Server license. The downside is that the report designer is probably the most child-like of all.
Crystal has been around forever, some love it, many hate it, it does the job, but has a serious price tag involved if you want to use it for anything other than personal use. And the web reporting server for it is VERY expensive.
ActiveReports, XtraReports, Telerik all have good products and all are being actively improved (at different speeds, of course). Each has a web viewer, but they don't include the rest of the things you might want from a web reporting server.
And if you find you really want an enterprise-class web server option for Crystal, ActiveReports, XtraReports or Telerik reporting (or any other report designer, for that matter), that's now available from www.versareports.com.
DevExpress XtraReports 套件。
报告只是一个类，不涉及 Web 服务或 rpt 文件。
http://www.devexpress.com/Products/NET/Reporting/
DevExpress XtraReports Suite.
A report is simply a class, no web services or rpt files involved.
http://www.devexpress.com/Products/NET/Reporting/