Crystal Reports与Microsoft SQL Server Reporting Services

I am developing a WPF application, and I need your advice.

我正在开发一个WPF应用程序，我需要你的建议。

I have to generate reports in my application. What should I use, Crystal Reports or SQL Server Reporting Services? Which one is better, and why?

我必须在我的应用程序中生成报告。我应该使用什么，Crystal Reports或SQL Server Reporting Services？哪一个更好，为什么？

4 个解决方案

#1

I have used both Although Crystal Reports is very well known and widely used. It can be a hassle at times (Not saying that SQL Server reporting services is not a hassle sometimes.)
Pros for Crystal Reports

虽然Crystal Reports是众所周知且广泛使用的，但我已经使用了它们。有时候这可能很麻烦（并不是说SQL Server报告服务有时候不麻烦。）Crystal Reports的优点

Many people use it and understand how to use it.
许多人使用它并了解如何使用它。
Its ability in the creation of more basic to intermediate reports quickly is a plus.
它能够快速创建更多基础到中间报告的能力是一个优势。
Even if you don't know SQL you can still fiddle with Crystal Reports to get the result you want, and flatten out the data.
即使您不了解SQL，您仍然可以使用Crystal Reports来获得所需的结果，并将数据展平。
Supports Dynamic Cascading Prompts (version XI and Higher)
支持动态级联提示（版本XI和更高版本）
Supports Web Viewer, ActiveX, Java and HTML.
支持Web Viewer，ActiveX，Java和HTML。

Cons for Crystal Reports

Crystal Reports的缺点

Crystal's Report Design Component seems to be full of strange scenarios.
Crystal的Report Design Component似乎充满了奇怪的场景。
I believe because the software has changed hands so many times. Documentation is pretty limited for the Report Design Component.
我相信因为软件已经转手了很多次。报告设计组件的文档非常有限。
A beginner can definitely create a nice formatted report quickly and easily, but when it comes to more complex reports where performance is needed. Going back to understanding SQL is necessary.
初学者肯定可以快速轻松地创建一个很好的格式化报告，但是当涉及需要性能的更复杂的报告时。回到理解SQL是必要的。

Pros for SQL Server Reporting

SQL Server报告的优点

Web Based Reporting Server
基于Web的报告服务器
Report Rendering Engine supports a number of formats (Excel, HTML, Image, and more)
报表呈现引擎支持多种格式（Excel，HTML，图像等）
Publishing and scheduling is a part of Reporting Services. In crystal you need Crystal Reports Server or Business Objects Enterprise for Publishing and scheduling. Or you would need to create your own custom app)
发布和计划是Reporting Services的一部分。在Crystal中，您需要Crystal Reports Server或Business Objects Enterprise进行发布和计划。或者你需要创建自己的自定义应用程序）
Parameter prompting is nicer in my opinion
在我看来，参数提示更好
Saved Data sources can be accessed by excel users.
excel用户可以访问已保存的数据源。
User login and permissions are built in.
用户登录和权限是内置的。
Subscriptions are a built in feature
订阅是内置功能

Cons for SQL Server Reporting

SQL Server报告的缺点

It can sometimes be a pain to implement
实施它有时会很痛苦
the Report builder feature for building simple reports is somewhat limited
用于构建简单报告的“报告”构建器功能有限
The best report builder is Visual Studio's Business Intelligence Studio. This is only a con because for a beginning end user this could seem overwhelming
最好的报表生成器是Visual Studio的Business Intelligence Studio。这只是一个骗局，因为对于初级终端用户而言，这似乎是压倒性的

In all SQL Server Reporting Services is my pick.

在所有SQL Server Reporting Services中都是我的选择。

#2

I use SSRS in a big project and start using it from 3 years ago. it is a very good solution. I recommend you to use SSRS not Crystal Reports.

我在一个大项目中使用SSRS并从3年前开始使用它。这是一个非常好的解决方案。我建议您使用SSRS而不是Crystal Reports。

#3

In the Following Link, the first two answers (one who supports SSRS and the other who supports CR) and they are giving their opinion about it.

在以下链接中，前两个答案（一个支持SSRS，另一个支持CR），他们正在发表意见。

Compare SQL Server Reporting Services to Crystal Reports

将SQL Server Reporting Services与Crystal Reports进行比较

#4

Crystal Reports - 780 MB
Report Builder - 30 MB (still better and easier to use)

Crystal Reports - 780 MB报表生成器 - 30 MB（更好更容易使用）

#1