locked
What are the advantages of SSRS over Crystal Reports? RRS feed

  • Question

  • User246057125 posted

    Previously I developed complex reports using Crystal Reports. Is the same possible with SSRS and what are the other advantages of SSRS over Crystal Reports?

    Monday, March 19, 2012 5:43 AM

All replies

  • User2105670541 posted

    there are N number of advantages with SSRS, first of all its very nice and powerfull tool, you can connect to SQL, ORACLE, SSAS(MDX) scripts, ODBC and many other providers, it give better flexibility to create reports, Chart,Gauge,Maps are other advantages, Report inside a report, Document map, you can call the webservice data, can create your custom code, and is capable to handle hevay data. this is a normal user comments who use SSRS,

    for typical internet documentation please refer links below:

    http://stackoverflow.com/questions/168427/compare-sql-server-reporting-services-to-crystal-reports

    http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp

    http://www.erpsoftwareblog.com/2010/02/crystal-reports-vs-sql-server-reporting-services-clash-of-the-microsoft-dynamics-gp-reporting-titans/

    PS: I love SSRS :)

    Monday, March 19, 2012 5:53 AM
  • User246057125 posted

    you can connect to SQL, ORACLE, SSAS(MDX) scripts, ODBC and many other providers, it give better flexibility to create reports, Chart,Gauge,Maps are other advantages, Report inside a report, Document map, you can call the webservice data, can create your custom code, and is capable to handle hevay data.

    This is possible in Crystal Report too.

    The only reasons that makes me shift to SSRS are:

    1. Crystal Reports (version 10) is full of bugs that can make you halt at a very later stage.
    2. It does not support side-by-side installation. You cannot install version 10 and 13 side-by-side.
    3. Integration with Visual Studio is not quite smooth. You can land into unknown trouble anytime.
    Monday, March 19, 2012 5:58 AM
  • User2105670541 posted

    okay I'm not using Crystal reports for a long time, 2005 Crystal reports wasnt supporting SSAS initially, may be it changed later. but indeed they are not as strong as SSRS :). and your Point No 3: Exactly.

    Monday, March 19, 2012 6:04 AM