Home »

What are the major differences between Crystal and SQL reporting services?

Question ListCategory: .NETWhat are the major differences between Crystal and SQL reporting services?
jully882 author asked 8 years ago
1 Answers
ethanbrown author answered 8 years ago

Ease of hosting reports: – Using the URL technology in RS we can host reports more easily thanin crystal report where we need to make a UI for the same.

Supporting platforms: – Crystal can run on windows, IBM and sun while RS (reporting
services) can run only on windows environment.

Client tools: – In reporting services we have Business intelligence ( BI ) and development studio
while in crystal its Report designer.

Caching: – This achieved in crystal by using cache server while in reporting services it’s stored as
snapshots in Reportserver database.

Export formats:- In crystal we have HTML,PDF,Excel,XML,Word , PDF , RTF , CSV, text
files while in SQL Server 2005 we have all the formats above it also gives capability to extend
custom reporting formats.

Data sources:- Crystal support more data sources while RS only supports Microsoft and oracle

data sources. Crystal supports ADO, COM, Database excel Access, Exchange, NT, Xbase, JDBC,
File system and Paradox. RS supports only SQL Server, Oracle, ODBC, OLEDB and you can
also extend additional data sources which does not exists in crystal reports.

Version issues: – One of the main issues faced in crystal is it have different versions which makes
it difficult to use, while RS comes with SQL Server minimizing the version issue.
Web server support: – Crystal can run on IIS 5/6, Apache, lotus etc while RS works only with
IIS 5.0 and above.

Please login or Register to Submit Answer