Tuesday, 11 June 2013

Difference Between Crystal Reports and SSRS


Difference Between Crystal Reports and SSRS
(OR)
Difference Between Crystal Reports and SQL Server Reporting Services
S.No
Crystal Reports
SSRS
1
Ease of hosting reports:

Using the URL technology in RS we can host reports more easily than in crystal report .
Ease of hosting reports:

In SSRS, in order to host reports we need to make a UI for the same.

2
Supporting platforms:

Crystal Reports can run on windows, IBM and sun
Supporting platforms:

SSRS can run only on windows environment.
3
Client tools:

In crystal Reports, we have Report designer.
Client tools:

In reporting services we have Business intelligence ( BI ) and development studio.
4
Caching:

This achieved in Crystal Reports by using cache server.
Caching:

In SSRS,it is stored as snapshots in Reportserver database.
5
Export formats:

In Crystal Reports we have HTML,PDF,Excel,XML,Word , PDF , RTF , CSV, text files.
Export formats:

In SSRS, we have all the formats above it also gives capability to extend custom reporting formats.
6
Data sources:

Crystal Reports support more data sources which incudes ADO, COM, Database excel Access, Exchange, NT, Xbase, JDBC, File system and Paradox.
Data sources:

SSRS only supports Microsoft and oracle data sources,namely,SQL Server, Oracle, ODBC, OLEDB and we can also extend additional data sources which does not exists in crystal reports.
7
Version issues:

One of the main issues faced in crystal reports is it have different versions which makes it difficult to use
Version issues:

SSRS comes with SQL Server minimizing the version issue.

8
Web server support:

Crystal Reports can run on IIS 5/6, Apache, lotus etc
Web server support:

SSRS works only with IIS 5.0 and above.

No comments: