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