Difference Between Crystal Reports and SQL Server Reporting Services
S.NoCrystal 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. 2Supporting platforms:Crystal Reports can run on windows, IBM and sunSupporting platforms:SSRS can run only on windows environment. 3Client tools:In crystal Reports, we have Report designer.Client tools:In reporting services we have Business intelligence ( BI ) and development studio. 4Caching:This achieved in Crystal Reports by using cache server.Caching:In SSRS,it is stored as snapshots in Reportserver database. 5Export 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. 6Data 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. 7Version 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. 8Web server support:Crystal Reports can run on IIS 5/6, Apache, lotus etcWeb server support:SSRS works only with IIS 5.0 and above.