Difference between SSRS and Crystal Report

visual-studio-2010 reporting-services crystal-reports
Olrac picture Olrac · May 8, 2013 · Viewed 20.8k times · Source

I'm going to develop an application...Just wondering...

What are the difference between SSRS and Crystal Report?[Visual Studio 2010]

Can you provide pros and cons?

Answer

Chetan Sanghani picture Chetan Sanghani · May 8, 2013

I have used both Although Crystal Reports is very well know 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

  • May 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 an 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.

Related questions

Visual Studio 2010 not showing Crystal Report Viewer of Printing Tab in Toolbox?

Scenario : I have windows form Application and want to generate Crystal reports. I have downloaded Crystal report of SAP and Installed, designed all crystal reports (made data set,table adapter etc )but I can't add crystal report viewer because I …

Read More
I lost datasets pane in Visual Studio

I'm developing a report in the Business Intelligence studio and I lost my dataset. The pane was near toolbox, and it is gone. What is the name of the pane I should to reopen?

Read More
SSRS error on preview : "The size necessary to buffer the XML content exceeded the buffer quota" hides original error

I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly this hiding irritates me …

Read More