What users are saying about
Top Rated
137 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
488 Ratings
Top Rated
137 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

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
488 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 100

Likelihood to Recommend

Looker

If you're a company who's been in business for a few years, and can afford a Looker license, then I wouldn't really look anywhere else. We've looked at a TON of data analytics/BI tools over the years and Looker is, by far, the best we've seen. However, that comes with a cost. If you're a new startup, Looker probably isn't appropriate for you because of the cost.
Anonymous | TrustRadius Reviewer

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 | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Looker
7.2
SAP Crystal
8.0
Pixel Perfect reports
Looker
6.9
SAP Crystal
8.4
Customizable dashboards
Looker
7.9
SAP Crystal
7.7
Report Formatting Templates
Looker
7.0
SAP Crystal
7.8

Ad-hoc Reporting

Looker
7.5
SAP Crystal
7.7
Drill-down analysis
Looker
8.2
SAP Crystal
7.3
Formatting capabilities
Looker
7.3
SAP Crystal
8.1
Integration with R or other statistical packages
Looker
5.9
SAP Crystal
7.7
Report sharing and collaboration
Looker
8.6
SAP Crystal
7.8

Report Output and Scheduling

Looker
8.1
SAP Crystal
8.2
Publish to Web
Looker
8.2
SAP Crystal
7.9
Publish to PDF
Looker
7.8
SAP Crystal
8.9
Report Versioning
Looker
7.6
SAP Crystal
7.8
Report Delivery Scheduling
Looker
8.8
SAP Crystal
8.3
Delivery to Remote Servers
Looker
SAP Crystal
8.1

Data Discovery and Visualization

Looker
6.7
SAP Crystal
7.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
Looker
7.5
SAP Crystal
7.6
Location Analytics / Geographic Visualization
Looker
7.9
SAP Crystal
7.3
Predictive Analytics
Looker
4.6
SAP Crystal
7.8

Access Control and Security

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

Mobile Capabilities

Looker
6.0
SAP Crystal
7.4
Responsive Design for Web Access
Looker
7.5
SAP Crystal
7.7
Dedicated iOS Application
Looker
5.0
SAP Crystal
7.0
Dedicated Android Application
Looker
5.0
SAP Crystal
7.2
Dashboard / Report / Visualization Interactivity on Mobile
Looker
6.7
SAP Crystal
7.6

Application Program Interfaces (APIs) / Embedding

Looker
SAP Crystal
6.9
REST API
Looker
SAP Crystal
7.4
Javascript API
Looker
SAP Crystal
6.8
iFrames
Looker
SAP Crystal
7.1
Java API
Looker
SAP Crystal
6.6
Themeable User Interface (UI)
Looker
SAP Crystal
6.8
Customizable Platform (Open Source)
Looker
SAP Crystal
6.6

Pros

Looker

  • Incredibly advanced analytics tool that is even more capable if you learn how to use LookML which is Looker's custom programming language.
  • Quick access to the raw data that is being visualized allows you to spot check for data integrity.
  • My usage with Looker is limited because of our integration but, having seen their updates over time, the integrations with Slack, Salesforce, and other tools appear to greatly improve organizations' workflows.
Anonymous | TrustRadius Reviewer

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 | TrustRadius Reviewer

Cons

Looker

  • Mobile viewing is HTML based, not always highly viewable.
  • Basic operations can be difficult to achieve. There is a function called table calculations which allows this.
  • Running on a single server, the entire instance can slow down if even one user schedules a large dashboard.
Anonymous | TrustRadius Reviewer

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 | TrustRadius Reviewer

Likelihood to Renew

Looker

Looker 9.0
Based on 4 answers
We've been very happy with Looker so far, and all teams in the organization are starting to see its value, and use it on a frequent basis. It has quickly become our accessible "source of truth" for all data/metrics.
Anonymous | TrustRadius Reviewer

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 | TrustRadius Reviewer

Usability

Looker

No score
No answers yet
No answers on this topic

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 | TrustRadius Reviewer

Support Rating

Looker

Looker 10.0
Based on 4 answers
Looker support specialists are heroes. They are knowledgeable, smart, and always vouch for your success. The availability is super quick, and even if there is no current solution for my problem, they will address it and voice it as feedback for a product.
Jasmeet S Babra | TrustRadius Reviewer

SAP Crystal

SAP Crystal 3.9
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 | TrustRadius Reviewer

Implementation Rating

Looker

No score
No answers yet
No answers on this topic

SAP Crystal

SAP Crystal 8.8
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 | TrustRadius Reviewer

Alternatives Considered

Looker

Looker stacks up very well against the other tools we have evaluated and used. All the tools have their own pros and cons. Looker had a better edge in terms of visualizations when we chose to use it. After several updates, other tools began to have newer features. Looker still stands competitive.
Purav Vaidya | TrustRadius Reviewer

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 | TrustRadius Reviewer

Return on Investment

Looker

No answers on this topic

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 | TrustRadius Reviewer

Screenshots

Pricing Details

Looker

General

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

Looker Editions & Modules

Additional 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 2020 - Full version$4951
SAP Crystal Server 2020 1 NUL$8692
SAP Crystal Server 2020 5 CAL$8,7443
SAP Crystal Reports Viewer 2020$04
SAP Crystal Reports 2020 - Upgrade$2954
  1. per user
  2. per named user
  3. per 5 concurrent users
  4. per user
Additional Pricing Details
* SAP Crystal Reports 2020 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2020 - 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 2020 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2020, 1 NUL includes 1 license of: SAP Crystal Reports 2020 - SAP Crystal Server 2020. * As an add-on to SAP Crystal Server 2020 1 NUL, SAP Crystal Server 2020 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.

Rating Summary

Likelihood to Recommend

Looker
8.2
SAP Crystal
8.1

Likelihood to Renew

Looker
9.0
SAP Crystal
10.0

Usability

Looker
SAP Crystal
8.1

Reliability and Availability

Looker
SAP Crystal
8.0

Performance

Looker
SAP Crystal
8.0

Support Rating

Looker
10.0
SAP Crystal
3.9

In-Person Training

Looker
SAP Crystal
10.0

Implementation Rating

Looker
SAP Crystal
8.8

Scalability

Looker
SAP Crystal
7.0

Add comparison