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 7.9

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

(558)

Attribute Ratings

Reviews

(1-25 of 117)
Companies can't remove reviews or game the system. Here's why
Akhilesh Arya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
SAP Crystal reports are generally in more formatted way where you can design header according to your requirements and data will be fetched from the data source accordingly. According to my analysis this is the only thing when required i'll be happy to use SAP Crystal report instead of power BI.
Score 9 out of 10
Vetted Review
Verified User
SAP Crystal Reports contains all the reporting capabilities of the above peer technologies. There is not a single capability of the above tools which is not available in Crystal report. But Crystal being an offering SAP fares and performs best for SAP integrated source systems. Even it also provides seamless connectivity from data sources.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Qlik Sense and Qlik View are all good tools and provide similar views and analyses like SAP Crystal. However, SAP Crystal is quite easy to use and more intuitive for people who have no background with coding and cloud-based tools. The ability to automate generating and sending reports is setting the tool apart.
Gene Baker | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We found that Crystal was a little more intuitive to our team members than the other products. All of the products were excellent choices but we liked the ability to code stored procedures to gather our data. While each product has very similar features, we went with Crystal given how long it has been on the market, the ease of finding developers skilled in Crystal and the fact that we've used it since 2003. We have evaluated many products over the years as we look for new features but always stay with Crystal. Another key feature was how we can schedule reports and generate and deliver them to our customers. Each week we generate thousands of reports without issue.
February 15, 2020

Decent reporting tool

Score 8 out of 10
Vetted Review
Verified User
Incentivized
Qlik is better in terms of reading data from different sources but it doesn’t have the auto doc ability like SAP Crystal Tableau. It is a decent visualization tool but doesn’t have the same ability in terms of rendering output reports into a suitable format. Plus the cost of Tableau is quite high.
Yoni Dvorkis | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We've had SAP Crystal for about ten years at this point. We've never really evaluated any alternatives since, as of today, well over 400 reports are being generated in the system, and we've yet to consider switching to a competing product.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
For automating documents and reports, I personally believe there is no better solution. However, for the sheer fact, it can't compare/combine two sources, I'd recommend pairing it with another BI tool. For example, Qlik, whereby you can create dashboards and compare multiple data sources but lacks the document automation. Another option would be to look into Tableau or Power BI.
January 08, 2020

SAP Crystal Review

Score 7 out of 10
Vetted Review
Verified User
Incentivized
We originally purchased Crystal as it aligned with our vendors' recommendations for reporting. We have since started to focus our development on more self-service and dashboard-type tools (like QlikView, Qlik Sense, and similar). These tools are more mature and capable than standard reporting tools in general, but not specific to Crystal.
Jesus Chacon | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We develop our desktop applications in Visual Studio IDE, we use SQL Server as a database engine, and the reports are managed by SAP Crystal since it does not limit us when it comes to displaying data. It supports all kinds of information from images and graphics.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
For standard pixel perfect reporting, our company still uses Crystal Reports. It allows us to continually provide standard reporting to our clients. For dashboards, we are moving towards Microsoft Power BI. Power BI allows similar collaboration, but generally has better features for dashboards. Power BI also allows us to publish multiple reports and dashboards into a single app for our end users.
Miguel De La Garza Rodriguez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Fully integrates into SAP B1 menus, it is the only reporting tool that fully integrates with B1 client, otherwise if you dont run SAP you can have all the reporting power and run reports from the crystal report viewer tool but you will not have menu like reports and you will need to do some customization to achieve menu like reports
Score 3 out of 10
Vetted Review
Verified User
Incentivized
As I stated in the previous question, the SQL Server reporting engine provides necessary scheduling services to allow for employee self-service. It also supports granular security, based upon active directory, to control who can see which report. SAP Crystal is still superior when it comes time to produce a highly formatted report. If it is any time after 2005, I would skip Crystal.
Frank Hunt | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Crystal offered a more straightforward implementation for our situation. While Tableau offers well-designed reports, the overall functionality regarding data manipulation and analysis is behind Crystal.

Compared to MS Excel, the possibilities of Crystal are virtually endless, providing a completely new and fresh view over the performance of the company as a whole.
December 06, 2018

SAP Crystal Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
I didn't make the decision in terms of selecting the software for the department. However, SAP Crystal is a great tool for a medium size department to increase their efficiency. There might be a different software on the market but I haven't used any similar software except Excel spreadsheet for similar work.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We actually have all 3 in place and all 3 are used in different situations. Some are bundled with certain products so we continue to use them. Others such as BI from Microsoft are stand alone and allow for easier data visualizations than SAP Crystal does. We chose SAP Crystal because it came bundled with our ERP software.
Damien Dolan | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We didn't so much evaluate them as use them side by side. Crystal was already here so we didn't replace it or think to replace it. We just added other programs that do things better. Both Power B and Dynamics are good at visualizing data in charts. Crystal is the workhorse
Dell Stinnett-Christy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I have done a little bit in Microsoft SSRS and a bunch in SAP Web Intelligence (Webi). Both of those are good at what they do. Like Crystal, SSRS is more technical. Webi is great for quick ad-hoc reports or data analyses. But with Crystal I can easily do things like picture-perfect form letters and other types of operational reporting.
Tom Fragale | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
PowerBI is starting to replace Crystal Reports. PowerBI is a Microsoft tool. It also brings different types of data in to the same report. PowerBi allows for more data types than Crystal does. Crystal Reports allows you to create formulas easier than PowerBI does. I am very familiar with both tools.
Return to navigation