locked
Crystal reports or SSRS 2008 RRS feed

  • Question

  • Can someone Point me to a website which compares the most latest versions of Crystal & SSRS? My company is looking to either go with SSRS or Crystal? Which one is better?
    FM
    Wednesday, February 16, 2011 3:15 PM

Answers

  • Hi,

     

    The choice of every reporting tool depends on your needs. Both products are very similar when creating and formatting reports.

     

    Crystal Reports (CR) is a business intelligence application used to design and generate reports from a wide range of data sources. Several other applications, including Microsoft Visual Studio, at one time bundled an OEM version of CR as a general purpose reporting tool. CR allows users to graphically design data connections and report layout.

     

    SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. SSRS updated quickly, the latest release is 2008 R2. In SSRS 2008 R2, you can access the new Report Part Gallery for "grab and go" reporting by using existing report subcomponents as building blocks to create new reports, display geographical data with new map and geospatial visualization capabilities, achieve more seamless interoperability with SharePoint for report access, collaboration and management and the use of SharePoint lists as data source for reporting, encapsulate enterprise data source by means of data feeds accessible through published reports. SSRS uses the Visual Studio-based Business Intelligence Development Studio (BIDS) to build integration, reporting, and analytic solutions in a unified environment. SSRS can create reports from a wide range of data sources, including SQL Server, Oracle, DB2, SAP, Netweaver BI, PowerPivot workbooks, SharePoint lists, SQL Server Parallel Data Warehouse, SQL Azure and others. Overall, for individuals, SSRS is easy to learn and use, for your corporation, the cost is low relatively.

     

    Here is a similar thread you can refer to:

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b85805dc-a74f-462d-9f7e-1607847eeffb/

     

    Thanks,

    Albert Ye

    • Proposed as answer by Jason Tom Thomas Wednesday, February 23, 2011 11:39 AM
    • Marked as answer by Challen Fu Friday, February 25, 2011 10:47 AM
    Wednesday, February 23, 2011 9:53 AM

All replies

  • Hi,

     

    The choice of every reporting tool depends on your needs. Both products are very similar when creating and formatting reports.

     

    Crystal Reports (CR) is a business intelligence application used to design and generate reports from a wide range of data sources. Several other applications, including Microsoft Visual Studio, at one time bundled an OEM version of CR as a general purpose reporting tool. CR allows users to graphically design data connections and report layout.

     

    SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. SSRS updated quickly, the latest release is 2008 R2. In SSRS 2008 R2, you can access the new Report Part Gallery for "grab and go" reporting by using existing report subcomponents as building blocks to create new reports, display geographical data with new map and geospatial visualization capabilities, achieve more seamless interoperability with SharePoint for report access, collaboration and management and the use of SharePoint lists as data source for reporting, encapsulate enterprise data source by means of data feeds accessible through published reports. SSRS uses the Visual Studio-based Business Intelligence Development Studio (BIDS) to build integration, reporting, and analytic solutions in a unified environment. SSRS can create reports from a wide range of data sources, including SQL Server, Oracle, DB2, SAP, Netweaver BI, PowerPivot workbooks, SharePoint lists, SQL Server Parallel Data Warehouse, SQL Azure and others. Overall, for individuals, SSRS is easy to learn and use, for your corporation, the cost is low relatively.

     

    Here is a similar thread you can refer to:

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b85805dc-a74f-462d-9f7e-1607847eeffb/

     

    Thanks,

    Albert Ye

    • Proposed as answer by Jason Tom Thomas Wednesday, February 23, 2011 11:39 AM
    • Marked as answer by Challen Fu Friday, February 25, 2011 10:47 AM
    Wednesday, February 23, 2011 9:53 AM
  • “Despite my past affair with Crystal Reports, I have to report that I’ve thrown over my loyalty to Stonefield Query. The simplicity and depth of the program make it easy for me to recommend. “ Doug Wolf, Author - Crystal Reports for Dummies
    Monday, May 9, 2011 4:02 PM
  • Some useful links that provide high-level overviews of Crystal Reports XI and SSRS on SQL Server 2005.  Both were written before SQL 2008 was released:

    They don't go into great detail, but I can concur my experience with what the authors are saying from a report developer experience.

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

    http://www.devx.com/codemag/Article/36397/1954?pf=true

    I would also agree with Albert's note that every reporting tool depends on your needs.

    Regards,

    Ryan

    Tuesday, May 17, 2011 2:41 PM