水晶报表与Microsoft SQL Server报表服务 [英] Crystal Reports vs. Microsoft SQL Server Reporting Services
问题描述
我正在开发一个WPF应用程序,我需要你的建议。
我必须在我的应用程式中产生报表。我应该使用什么,Crystal Reports或SQL Server Reporting Services?哪个更好,为什么?
我已经使用了
虽然水晶报表是非常知名的,用过的。它可能是一个麻烦有时(不是说SQL Server报告服务有时不是一个麻烦。)
水晶报表的优点
- 许多人使用它并了解如何使用它。
- 它在创建更多基本到中间报告的能力是一个加号。
- 即使你不知道SQL,你仍然可以使用Crystal Reports来获取所需的结果,并展平数据。
- 支持动态层叠提示和更高版本)
- 支持Web查看器,ActiveX,Java和HTML。
水晶报表的缺点
- Crystal
- 我相信因为软件有
改变了这么多次。
文档对于
的报表设计组件非常有限。 - 一个初学者可以很容易地创建一个
格式的报表,
,但是当涉及更多的
复杂的报告,性能是
需要。回到理解
SQL是必要的。
SQL Server报告的优点
- 基于网络的报表服务器
- 报表呈现引擎支持
格式数(Excel,HTML,
Image,和更多) - 发布和计划是Reporting Services的一部分
。在水晶中你
需要Crystal Reports Server或
Business Objects Enterprise用于
发布和调度。或者
需要创建自己的自定义
应用程序) - 参数提示在我的
意见中更好 -
excel用户可以访问已保存的数据源。 - 内置用户登录和权限。
- 订阅是
- 最好的报表生成器是Visual Studio的商业智能工作室。
在所有的SQL Server报表服务是我的选择。 p>
I am developing a WPF application, and I need your advice.
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?
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
- 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.
- Supports Dynamic Cascading Prompts (version XI and Higher)
- Supports Web Viewer, ActiveX, Java and HTML.
Cons for Crystal Reports
- Crystal's Report Design Component seems to be full of strange scenarios.
- 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.
Pros for SQL Server Reporting
- Web Based Reporting Server
- Report Rendering Engine supports a number of formats (Excel, HTML, Image, and more)
- 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)
- Parameter prompting is nicer in my opinion
- Saved Data sources can be accessed by excel users.
- User login and permissions are built in.
- Subscriptions are a built in feature
Cons for SQL Server Reporting
- 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
In all SQL Server Reporting Services is my pick.
这篇关于水晶报表与Microsoft SQL Server报表服务的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!