Skip to main content
TrustRadius
SAP Crystal

SAP Crystal

Overview

What is SAP Crystal?

SAP Crystal is an analytics and reporting software solution for SMBs. SAP Crystal comprises Crystal Reports for pixel-perfect reporting, and SAP Crystal Server for automated distribution and self-service access to reports, dashboards and data exploration.

Read more
Recent Reviews

Decent reporting tool

8 out of 10
February 15, 2020
Incentivized
I used SAP Crystal for report visualization. The graphs in the tool are outstanding with strong information telling ability combining with …
Continue reading

SAP Crystal Review

7 out of 10
January 08, 2020
Incentivized
Crystal is used enterprise-wide for pixel-perfect reporting. We have both on-demand reporting use cases, and scheduled reporting via email …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 29 features
  • Publish to PDF (131)
    10.0
    100%
  • Report sharing and collaboration (118)
    10.0
    100%
  • Report Formatting Templates (115)
    10.0
    100%
  • Formatting capabilities (133)
    10.0
    100%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Upgrade Version to SAP Crystal Reports 2020

$295

On Premise
per single user license

SAP Crystal Reports 2020 64-Bit

$495

On Premise
per single user license

SAP Crystal Reports 2016 32-Bit

$495

On Premise
per single user license

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttp://www.sapstore.com/solutions/99013…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

Software TRAIL DEMO SAP Crystal Reports 2013

YouTube

SAP Crystal Dashboard Design - Demo video

YouTube
Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

9.3
Avg 8.2

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

9.6
Avg 8.1

Report Output and Scheduling

Ability to schedule and manager report output.

9.4
Avg 8.4

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

8
Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

8.6
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

8.4
Avg 8.0

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

7
Avg 7.9
Return to navigation

Product Details

What is SAP Crystal?

SAP Crystal Reports and SAP Crystal Server are designed to help users create pixel-perfect, richly formatted, and dynamic reports from virtually any data source – delivered in dozens of export formats, in up to 24 languages. SAP Crystal Reports is a production reporting tool designed to turn almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices. SAP Crystal Server enables self-service access to reports, dashboards, and data exploration within a secure infrastructure.

SAP Crystal Features

BI Platform Features

  • Supported: Administration via Web Interface
  • Supported: Live Connection to External Data
  • Supported: Snapshot of External Data
  • Supported: OLAP (Pre-processed cube representation)
  • Supported: ROLAP (SQL-layer querying)
  • Supported: Multi-Data Source Reporting (Blending)
  • Supported: Data warehouse / dictionary layer

Supported Data Sources Features

  • Supported: MS Excel Workbooks
  • Supported: Text Files (CSV, etc)
  • Supported: Oracle
  • Supported: MS SQL Server
  • Supported: IBM DB2
  • Supported: Postgres
  • Supported: MySQL
  • Supported: ODBC
  • Supported: EMC Greenplum
  • Supported: HP Vertica
  • Supported: SAP Hana
  • Supported: Teradata
  • Supported: Salesforce
  • Supported: SAP

BI Standard Reporting Features

  • Supported: Pixel Perfect reports
  • Supported: Customizable dashboards
  • Supported: Report Formatting Templates

Ad-hoc Reporting Features

  • Supported: Drill-down analysis
  • Supported: Formatting capabilities
  • Supported: Integration with R or other statistical packages
  • Supported: Report sharing and collaboration

Report Output and Scheduling Features

  • Supported: Publish to Web
  • Supported: Publish to PDF
  • Supported: Output Raw Supporting Data
  • Supported: Report Versioning
  • Supported: Report Delivery Scheduling
  • Supported: Delivery to Remote Servers

Data Discovery and Visualization Features

  • Supported: Location Analytics / Geographic Visualization

Access Control and Security Features

  • Supported: Multi-User Support (named login)
  • Supported: Role-Based Security Model
  • Supported: Multiple Access Permission Levels (Create, Read, Delete)
  • Supported: Report-Level Access Control
  • Supported: Table-Level Access Control (BI-layer)
  • Supported: Field-Level Access Control (BI-layer)
  • Supported: Single Sign-On (SSO)

Mobile Capabilities Features

  • Supported: Responsive Design for Web Access
  • Supported: Mobile Application
  • Supported: Dashboard / Report / Visualization Interactivity on Mobile

Application Program Interfaces (APIs) / Embedding Features

  • Supported: Javascript API
  • Supported: Java API
  • Supported: Themeable User Interface (UI)
  • Supported: Customizable Platform (Open Source)

SAP Crystal Screenshots

Screenshot of Pixel-perfect reporting solutionScreenshot of Refresh with a clickScreenshot of Build pixel-perfect documentsScreenshot of Connect to all data sourcesScreenshot of Use drag and dropScreenshot of Build interactive reportsScreenshot of Export to popular formats

SAP Crystal Videos

SAP Crystal Solutions: The Mobile Worker Use Case
SAP Crystal Solutions: Identify and Eliminate Clutter in Your Visualizations
SAP Crystal Solutions: How to Buy SAP Crystal Reports Digitally

SAP Crystal Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Linux
Mobile ApplicationApple iOS, Android
Supported CountriesGlobal
Supported LanguagesEnglish, French, German, Japanese, Spanish, Simplified Chinese, Italian, Dutch, Russian, Korean, Traditional Chinese, Portuguese, Swedish, Polish, Danish, Norwegian, Finnish, Thai, Czech, Hungarian, Slovakian, Turkish, Romanian, Slovenian

Frequently Asked Questions

SAP Crystal is an analytics and reporting software solution for SMBs. SAP Crystal comprises Crystal Reports for pixel-perfect reporting, and SAP Crystal Server for automated distribution and self-service access to reports, dashboards and data exploration.

Windward Core, Jaspersoft, and Jet Reports are common alternatives for SAP Crystal.

Reviewers rate Customizable dashboards and Report Formatting Templates and Drill-down analysis highest, with a score of 10.

The most common users of SAP Crystal are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(555)

Attribute Ratings

Reviews

(101-125 of 145)
Companies can't remove reviews or game the system. Here's why
October 27, 2016

Great Reporting Tool

Score 8 out of 10
Vetted Review
Verified User
Incentivized
The entire company is using Crystal Reports to make reports that track progress and performance in the various departments. A few different business problems are addressed by Crystal Reports, mainly tied to how we are performing versus our KPIs and we address issues based on the reports that we create.
Joal Kieboam | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SAP Crystal Server is used by me personally as I am currently the only person working at my company. This product allows me to easily find and organize my files and information. Reports are easy to generate and understand. I no longer have to generate multiple reports as with software I've used in the past. SAP Crystal Server does it all in one.
September 08, 2016

Trusty reports, easy to use

Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use it in the engineering department to run standard reports for projects (i.e. to track if we are on schedule, budget, etc.). I know the program is also used by more departments, but not by the whole organization, and not in all of our global offices at the moment.
September 08, 2016

Crystal Server Overview

Score 7 out of 10
Vetted Review
Verified User
Incentivized
Select departments use SAP Crystal Server. It is used for creating reports, mainly to track how efficient customer orders are being filled, prepared, and shipped. Reports are also produced that track if any material is wasted in the factory during production. Corporate produces reports to track how efficient each location is with the other.
Score 8 out of 10
Vetted Review
Verified User
Incentivized

SAP Crystal Reports is used for users and roles mapping. This is easy to use, from basic reports to the more complex. It's easy for a manager to know what to request as access for particular transaction codes and roles for the required position.

It is also used for reporting segregation of duties (SOD) at intra roles and the user level. We also use reports for analyzing these reports for audits.

August 12, 2016

Great for SQL

Ken Smith | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We install and support Crystal Reports across multiple clients. It's mainly used to pull data out of SQL Server into customized reports. Usually the canned reports out of database driven software are inadequate and clients need to access data with custom reports.
Craig Nash | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Incentivized
Crystal reports was being used to create reports pertaining to how many hours the staff were dedicating to specific duties within the company. As this company was a high-frequency trading firm, finding alternative ways of automating different employee tasks helped to reduce down the total overhead while allowing the staff to devote more time to the more important aspects of the business. The intelligence that Crystal Reports generated provided a lot of insight into just how much time was really being wasted in areas of the business that really did not need a person performing, yet were never automated with software as it was perceived that much less time was being used up by these tasks.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SAP Crystal Reports is being used to create all business reporting across all functions of the business. We use it to make a physical schedule, measure KPIs, and track sales. In addition, all labels that are applied to products are printed with reports built in Crystal Reports. Each function has its own reports that have been created to show what materials are required when, where they need to go, and what needs to be done to them. Crystal Reports has greatly increased the visibility of the process and has increased efficiency on the shop floor.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Infor VISUAL Enterprise software. It has a fairly limited report writer. Crystal Reports allows us to retrieve any information we need easily and effectively. Due to the cost of Crystal Reports, we have 4 stations where reports can be created. Crystal Reports allows us to use Visual in a slightly different way than it was designed. We can focus on teams of people rather than machines.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Crystal Reports allows us to mine a wide variety of data from our accounting system and other data bases and turn it into valuable reports. If you know a little bit about data it's relatively easy to pick out the data you want, sort it, relate it to other data, run all sorts of calculations on it and turn it into a nicely formatted report. We even have a couple of reports that makes graphs out of the data. We use the reports for inventory control, sales analysis, all kinds of accounting reports, etc.
Chris Jensen | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Crystal Reports in the custom software applications we write for our clients as well as for our internal software development projects. We also have clients which we'll go on-site at their office and help with report modifications and/or training if needed.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Crystal Reports allows us to customize our invoicing and statements which means we do not have to get special forms printed, resulting in a great cost savings to our company. We are able to have reports built to suit our reporting requirements specifically, as well as use the ones within our accounting software easily. We are able to make financial statements easily in house, and make changes without having to go to an outside source. It is relatively easy to use with a little bit of learning.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is being used across the sales department; mostly for proposals and integrated with Tigerpaw Software that we use daily for quotes. We use SAP Crystal Reports to write up the formulas for our monthly leasing charges and to put in materials that go into a quote.
We can easily adjust the formulas for quotes, so that each template is different. It's very easy to save the template and create a new one if needed. We do phone systems, cabling, security systems, etc., so we do not use the same quote template each time. It's very easy to use.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is used by my department. It helps show sales history, trends and comparison reports and helps us track conversion ratios and growth. It also helps us see how we do in sales by vendor along with quantities and costs. I really like the line charting and linear regression features.
Marie Rodriguez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Crystal Reports to access data within our legacy system. Since Crystal Reports can access data from multiple data sources, we are able to combine data from dbase, along with access, MS SQL, and mySQL databases. I extract data from the databases to provide to our bookkeeper, executives, and team members for ad-hoc reports and financial accounting. Our dbase databases are difficult to read. I am able to pull the data out with simple queries easily. The one thing that I have a problem with is getting the data at the same time from multiple data types. Frequently, if I need to get data from dbase and Access, I must create sub-reports and append them. But, I would expect that since dbase is so old.
Cory Smith | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Crystal reports to pull data from all of our databases. We use it across the whole organization. We produce reports for analysis, massage data to be able to pull out meaningful trends and export data in various formats for our partners.
Joey McDonald | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Crystal Reports to help with various month end procedures, ad hoc reports as well as provide other departments with reports that they can access using a Crystal Reports viewer. It helps provide a lot of insight into the company that the canned reports of our accounting system does not offer.
Return to navigation