Difference
Between Crystal Reports and SSRS
(OR)
Difference Between Crystal Reports and SQL Server Reporting Services
(OR)
Difference Between Crystal Reports and SQL Server Reporting Services
-
S.No Crystal ReportsSSRS1Ease 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 sunSupporting 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 useVersion issues:SSRS comes with SQL Server minimizing the version issue.8 Web server support:Crystal Reports can run on IIS 5/6, Apache, lotus etcWeb server support:SSRS works only with IIS 5.0 and above.
No comments:
Post a Comment