Crystal Reports vs. Microsoft SQL Server Reporting Services

Question

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?

score 24 · Accepted Answer · edited Jan 20 '16 at 17:34

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.

score 3 · Answer 2 · answered Apr 18 '10 at 08:21

3

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.

answered Apr 18 '10 at 08:21

masoud ramezani

22,228
29
98
151

score 2 · Answer 3 · edited May 23 '17 at 10:28

2

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.

Compare SQL Server Reporting Services to Crystal Reports

edited May 23 '17 at 10:28

Community

1
1

answered Feb 25 '13 at 12:17

Muhammad Omar ElShourbagy

6,718
2
32
50

score 1 · Answer 4 · answered Jan 20 '14 at 08:14

1

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

answered Jan 20 '14 at 08:14

Bat_Programmer

6,717
10
56
67

Crystal Reports vs. Microsoft SQL Server Reporting Services

4 Answers4

Linked