Scribd
Upload
4 views2 pages

Crystal Reports vs SSRS Comparison

The document compares Crystal Reports and SQL Server Reporting Services (SSRS) across various aspects such as ease of hosting, supported platforms, client tools, caching, export formats, data sources, version issues, and server support. Crystal Reports supports a wider range of data sources and export formats, while SSRS is more streamlined for Windows environments and offers better version control. Additionally, SSRS allows for custom reporting formats and requires a user interface for hosting reports.

Uploaded by

MRLogan123
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Crystal Reports vs SSRS Comparison

The document compares Crystal Reports and SQL Server Reporting Services (SSRS) across various aspects such as ease of hosting, supported platforms, client tools, caching, export formats, data sources, version issues, and server support. Crystal Reports supports a wider range of data sources and export formats, while SSRS is more streamlined for Windows environments and offers better version control. Additionally, SSRS allows for custom reporting formats and requires a user interface for hosting reports.

Uploaded by

MRLogan123
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Difference Between Crystal Reports and SSRS

(OR)
Difference Between Crystal Reports and SQL Server Reporting Services
[Link] Crystal Reports SSRS
1 Ease of osting reports!
Using the URL technology in RS
we can host reports more easily
than in crystal report .
Ease of osting reports!
In SSRS, in order to host reports we
need to make a UI for the same.
2 S"pporting platfor#s!
Crystal Reports can run on
windows, I! and sun
S"pporting platfor#s!
SSRS can run only on windows
en"ironment.
# Client tools!
In crystal Reports, we ha"e
Report designer.
Client tools!
In reporting ser"ices we ha"e usiness
intelligence $ I % and de"elopment
studio.
& Cacing!
'his achie"ed in Crystal Reports
(y using cache ser"er.
Cacing!
In SSRS,it is stored as snapshots in
Reportser"er data(ase.
) E$port for#ats!
In Crystal Reports we ha"e
*'!L,+,-,./cel,0!L,1ord ,
+,- , R'- , CS2, te/t files.
E$port for#ats!
In SSRS, we ha"e all the formats
a(o"e it also gi"es capa(ility to e/tend
custom reporting formats.
3 Data so"rces!
Crystal Reports support more data
sources which incudes 4,5,
C5!, ,ata(ase e/cel 4ccess,
./change, 6', 0(ase, 7,C, -ile
system and +arado/.
Data so"rces!
SSRS only supports !icrosoft and
oracle data sources,namely,S8L
Ser"er, 5racle, 5,C, 5L., and
we can also e/tend additional data
sources which does not e/ists in
crystal reports.
9 %ersion iss"es!
5ne of the main issues faced in
crystal reports is it ha"e different
"ersions which makes it difficult
to use
%ersion iss"es!
SSRS comes with S8L Ser"er
minimi:ing the "ersion issue.
; &e' server s"pport! &e' server s"pport!
Crystal Reports can run on IIS
)<3, 4pache, lotus etc
SSRS works only with IIS ).= and
a(o"e.
(nd) f"rter "pdates on difference 'etween *"estions and answers) please visit #y 'log +
http><<onlydifferencefa?s.([Link]<

You might also like