What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
460 Ratings

SAP Crystal

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
460 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Likelihood to Recommend

SAP Crystal

Crystal reports is a great Business Intelligence tool for any midsize business that prefers to keep its data in-house instead of in the cloud. The learning curve for parsing data source and creating first reports could be a bit steep at the beginning, but then the cost savings are invaluable. The reports generated by Crystal are easily manipulated according to different requirements and further analyzed by the recipients.
Frank Hunt profile photo

Feature Rating Comparison

BI Standard Reporting

SAP Crystal
8.2
Pixel Perfect reports
SAP Crystal
8.5
Customizable dashboards
SAP Crystal
8.0
Report Formatting Templates
SAP Crystal
8.1

Ad-hoc Reporting

SAP Crystal
7.9
Drill-down analysis
SAP Crystal
7.5
Formatting capabilities
SAP Crystal
8.7
Integration with R or other statistical packages
SAP Crystal
7.5
Report sharing and collaboration
SAP Crystal
8.0

Report Output and Scheduling

SAP Crystal
8.2
Publish to Web
SAP Crystal
8.0
Publish to PDF
SAP Crystal
9.0
Report Versioning
SAP Crystal
7.9
Report Delivery Scheduling
SAP Crystal
8.1
Delivery to Remote Servers
SAP Crystal
8.0

Data Discovery and Visualization

SAP Crystal
7.6
Pre-built visualization formats (heatmaps, scatter plots etc.)
SAP Crystal
7.5
Location Analytics / Geographic Visualization
SAP Crystal
7.4
Predictive Analytics
SAP Crystal
7.7

Access Control and Security

SAP Crystal
7.7
Multi-User Support (named login)
SAP Crystal
8.0
Role-Based Security Model
SAP Crystal
7.6
Multiple Access Permission Levels (Create, Read, Delete)
SAP Crystal
7.6
Single Sign-On (SSO)
SAP Crystal
7.7

Mobile Capabilities

SAP Crystal
7.3
Responsive Design for Web Access
SAP Crystal
7.6
Dedicated iOS Application
SAP Crystal
6.9
Dedicated Android Application
SAP Crystal
7.2
Dashboard / Report / Visualization Interactivity on Mobile
SAP Crystal
7.5

Application Program Interfaces (APIs) / Embedding

SAP Crystal
7.2
REST API
SAP Crystal
7.5
Javascript API
SAP Crystal
7.3
iFrames
SAP Crystal
7.1
Java API
SAP Crystal
7.2
Themeable User Interface (UI)
SAP Crystal
7.2
Customizable Platform (Open Source)
SAP Crystal
6.8

Pros

SAP Crystal

  • Great visualization for static format & precise tasks: For presentation to senior management /ex-co/vendors where concise decisions need to be made, Crystal is a nice choice to slide data into presentable views.
  • Diverse data source connect: We have used it to write reports using data from DB2, SQL, Progress, Excel spreadsheets, XML data, Access, and Lotus Notes databases. It can also be used to join different database types together in one report.
  • It uses the "recurring bands" structure for page layout which is efficient and fungible for generating different types of reports. Crystal doesn't require that we set up a metadata layer before creating reports and provides direct access to tables and dimensions.
Rohit Narang profile photo

Cons

SAP Crystal

  • The option to export to Excel is very picky about report format to get a clean export. Once you know the tricks for setting up a report for this export, it's not hard to do, but it can be very tedious if the report has a lot of elements. This is the way it's been for years and SAP has indicated that it's not something that's going to be changed.
  • Crystal requires that a user knows how the data they're reporting on is configured in the database - it's not really suited for a "casual" user, but for someone with at least some technical skills in relation to databases. This is not something that can or should necessarily be changed, but it is something that potential users need to be aware of.
  • Other than new types of database connections, SAP has indicated that they will not be upgrading any functionality in "classic" Crystal. They instead have chosen to focus on upgrades to Crystal for Enterprise. The problem with that is that it requires the SAP BI Platform - either SAP BusinessObjects or SAP Crystal Reports Server.
  • One of the major things that's not being upgraded is the Charting libraries, which were last updated in the early 2000's, before SAP purchased Crystal. So, Crystal doesn't have newer chart types available.
Dell Stinnett-Christy profile photo

Likelihood to Renew

SAP Crystal

SAP Crystal 10.0
Based on 19 answers
I have made my career off Crystal Reports. Business Intelligence is a niche area of Information Technology that combines technical knowledge and an understanding of how a company uses information. Crystal Reports is the most solid, flexible and reliable business intelligence tool I have worked with, allowing me to work on projects in a variety of markets and industries, from the financial to educational, to telecommunications to governmental. Understanding how to use Crystal Reports as part of a Business Intelligence career gives you the tools you need to better connect businesses to their data, deliver quality and productive solutions, and allow you the report developer to build the experience and skills to build a reputable career in the high demand world of Business Intelligence Reporting.
David Deitch profile photo

Usability

SAP Crystal

SAP Crystal 8.1
Based on 22 answers
Crystal is very robust, but not always easy to use. It create wonderful looking reports, and so deserves a high rating. However, I have to take a couple of points off for the simple fact that I cannot hand it to a user and expect them to be able to do development with it.
Greg Goss profile photo

Support

SAP Crystal

SAP Crystal 5.1
Based on 15 answers
The support community can be difficult to navigate. I've also run into issues with my login. The SAP system has a bizarre mechanism for validating users that requires users to have what is called an S-ID. A basic ID may not give you access to all the features in the portal. The limitation may include not being able to perform a simple task like downloading patches and updates. This isn't a big deal for single user license but for teams it can be a pain.
Nathan Patrick Taylor profile photo

Implementation

SAP Crystal

SAP Crystal 8.7
Based on 14 answers
Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
John Suit profile photo

Alternatives Considered

SAP Crystal

As I said before I never used a reporting tool before Crystal Reports but I have since used SSRS. Crystal Reports blows SSRS out of the water. The reports look nicer and it was easier, faster, and better to create a report in Crystal Reports. Prior to using Crystal Reports I wrote reports by coding them using RPG on the iSeries. I could never go back to doing that.
Janet Fawcett profile photo

Return on Investment

SAP Crystal

  • Employee Empowerment - Now that our Crystal Reports are written and published, all of our team members have access to run the same reports across the company. Previously, there was only 1 point person in charge of running reports, which took a lot of time away from other job duties.
  • Increased Employee Efficiency - One of the Crystal Reports my company uses has allowed me to take a task that took 3 days to complete and cut the time down to 4 hours. There was a lot of manual data collection and calculations that were done, which has also led to less errors.
  • Accurate real-time data - Since Crystal Reports are very quick to run, we are able to give real time data to our customers rather than maintaining oudated databases in other systems such as Excel.
Shannon Odland profile photo

Pricing Details

SAP Crystal

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

SAP Crystal Editions & Modules

Edition
SAP Crystal Reports 2016 - Full version$4951
SAP Crystal Server 2016 1 NUL$8692
SAP Crystal Server 2016 5 CAL$8,7443
SAP Crystal Reports Viewer 2016$04
SAP Crystal Reports 2016 - Upgrade$2954
  1. per user
  2. per named user
  3. per 5 concurrent users
  4. per user
Additional Pricing Details
* SAP Crystal Reports 2016 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2016 - Full version allows you to create powerful, richly formatted, and dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. If you already have an older version of Crystal Reports, buy a license for SAP Crystal Reports 2016 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2016, 1 NUL includes 1 license of: SAP Crystal Reports 2016 - SAP Crystal Server 2016 - SAP Crystal Dashboard Design 2016. * As an add-on to SAP Crystal Server 2016 1 NUL, SAP Crystal Server 2016 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.

Add comparison