SAP Crystal

SAP Crystal

About TrustRadius Scoring
Score 7.9 out of 100
SAP Crystal

Overview

Recent Reviews

SAP Crystal Report Review

9
May 01, 2021
This tool is amazing for reporting. You can generate reports from different types of data sources easily. We are using this tool in the …

First time caller, long time user.

10
October 25, 2020
We use it as our main reporting tool as part of our software application for all internal and external reports.
Read full review

SAP Crystal overall satisfaction

7
March 31, 2020
SAP Crystal is being used by my organization to generate all kinds of reports across the entire organization. The company has been using …
Read full review

Crystal Delivers Thousands of Reports Per Week

8
February 18, 2020
We use Crystal Reports to generate over 200 standard reports for various data topics from our record-keeping system. These reports can be …
Read full review

Decent reporting tool

8
February 15, 2020
I used SAP Crystal for report visualization. The graphs in the tool are outstanding with strong information telling ability combining with …
Read full review

SAP Crystal Reports review

7
February 15, 2020
We use SAP Crystal to automate and generate a set of reports that are usually exported as PDF files directly to the user's email inboxes. …

Powerful document and report automation

9
January 10, 2020
We use SAP Crystal to generate documents in our ERP system for things such as sales, purchasing, invoice, manufacturing documents, and …
Read full review

SAP Crystal Review

7
January 08, 2020
Crystal is used enterprise-wide for pixel-perfect reporting. We have both on-demand reporting use cases, and scheduled reporting via email …
Read full review

Crystal

8
December 11, 2019
We use SAP Crystal reports inside our BI reporting in SAP Business Objects. We have multiple reporting options inside the Analytics, and …
Read full review

One of my top rated reporting systems.

10
December 07, 2019
SAP Crystal Reports software is used within the organization for creating reports from several hundred external resources. I would not say …
Read full review

Reviewer Sentiment

N/A
Positive ()
N/A
Negative ()
Learn how we calculate reviewer sentiment

Awards

TrustRadius Award Top Rated 2020
TrustRadius Award Top Rated 2019

Popular Features

View all 28 features

Publish to PDF (132)

9.3
93%

Report sharing and collaboration (119)

9.1
91%

Report Formatting Templates (116)

9.0
90%

Formatting capabilities (134)

8.9
89%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SAP Crystal, and make your voice heard!

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

Features Scorecard

BI Standard Reporting

8.7
87%

Ad-hoc Reporting

8.7
87%

Report Output and Scheduling

9.1
91%

Data Discovery and Visualization

7.9
79%

Access Control and Security

8.6
86%

Mobile Capabilities

8.4
84%

Application Program Interfaces (APIs) / Embedding

7.9
79%

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

Pixel-perfect reporting solutionRefresh with a clickBuild pixel-perfect documentsConnect to all data sourcesUse drag and dropBuild interactive reportsExport 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 Downloadables

SAP Crystal Integrations

  • SAP Crystal Reports for Visual Studio
  • SAP Crystal Reports for Eclipse

SAP Crystal Competitors

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

Comparisons

View all alternatives

Frequently Asked Questions

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.

What is SAP Crystal's best feature?

Reviewers rate Publish to PDF highest, with a score of 9.3.

Who uses SAP Crystal?

The most common users of SAP Crystal are from Mid-sized Companies (51-1,000 employees) and the Information Technology & Services industry.

Reviews

(1-25 of 157)
Companies can't remove reviews or game the system. Here's why
Emeka Opara | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • It can connect to various data sources
  • Quick logins and authorization syncing with SSO
  • It may be a bit hard to setup for a new user.
  • While it may be hard to setup it has a lot of great functionality that will come in handy once you are comfortable with it.
Akhilesh Arya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • It can connect to different data sources
  • Generates report with attractive charts and tables
  • Very flexible and easily customize-able
  • A little programming related to SQL and .NET is required for the efficient use of the tool
  • Adjusting spaces between multiple rows is a bit difficult task
  • Documentation part should be improved
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Highly formatted reporting capabilities.
  • Pixel oriented perfect reporting for printing.
  • Embedding of dynamic images/logo or barcodes for customized reports.
  • Easy to share with other users.
  • Dragging and dropping the elements into the canvas to fit in pixels is sometime difficult.
  • Exporting the report in Excel looses formatting.
  • Learning curve of Crystal is difficult for consultants as it's a bit tricky for data connections.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Fairly easy to learn the report designer. Even for people without strong database knowledge.
  • Ability to reuse existing report components.
  • Can design reports targeted for printing (can cleanly handle pagination).
  • Can report from multiple data sources without the need for a data warehouse.
  • Better handling of imported images from a database. Need to maintain aspect ratio.
  • Add option to disable grid lines.
  • Changing data source on same server needs a little TLC. Still have to change each table instead of just updating the connection.
  • Pivot Table formatting.
  • Chart formatting.
  • Importing formatted text from MS Word.
  • Support for HTML text formatting.
Gene Baker | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Complex queries are supported through the use of stored procedures. Because of this, we are able to create very complex reports to satisfy consumer needs.
  • User-friendly formats are supported and we can display these reports online.
  • Running multiple queries without using stored procedures.
  • We need to have developers write SQL code. Drag and drop type report creation can be difficult to accurately create without writing SQL. SQL relationships must be clearly defined for the drag and drop to work. This makes sense, otherwise, how would the tool know what the relationships are?
January 08, 2020

SAP Crystal Review

Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Pixel perfect reporting.
  • Enterprise grade stability.
  • Dated technology.
  • There's a lack of web-based development for Crystal reports (though it exists for WEBI and the like).
December 11, 2019

Crystal

Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Predefined Reports.
  • Corporate style guide.
  • Not for user to create the reports is a complex tool which needs IT assistance.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Easy to use UI. Basically, even a non-technical user can learn to do everything in a week.
  • The speed of compiling the data.
  • Useful templates.
  • Easy interface for integrating the data in the system from external sources.
  • Scheduled reports.
  • There are some specific points in the system which might become buggy or not easy to use, thus, require support.
  • A lot of functionalities to learn for new users.
Jesus Chacon | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • It has many interesting tools and functions when used with Visual Studio IDE. This allows us to integrate many features of the IDE to design each visual element using drag and drop controls to customize reports
  • We have been able to make successful connections to diverse data sources including SQL Server, MySQL, local and in the cloud
  • You can perform complex queries by incorporating SQL statements
  • There are no limits as to the type of data or objects that I can use. I can format the changes, add mathematical and logical functions, also add images configure the color fonts, all in design mode
  • There is no backward compatibility with versions of previous reports. Some updates could cause data loss
  • New versions take a long time to arrive
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Crystal Reports allows us to create a consistent template for all of our reports.
  • Crystal Reports and Server allows us to house a repository for all of our reports to make them easy to find and update when necessary.
  • Crystal Reports can connect to a wide variety of data sources.
  • Crystal Reports can be a little daunting when first implementing. There are a lot of nuances in learning how to truly master this software and it can be frustrating at times.
  • There are a lot of features in Crystal Reports that do not always work as expected. You may find yourself searching the Web for how to get the results that you want.
  • Crystal Reports does not provide updates on a regular basis. New concepts and ideas may be a while in implementing.
  • The initial setup can be frustrating. There are times when you need to go outside of the install package to make it work with particular data sources, etc. It is not always a 100% install.
Miguel De La Garza Rodriguez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Excelent integration on SAP B1 client install
  • Very easy for the user to access / export reports data
  • User permissions/controls to enable/disable unwanted users to access the reports
  • If IT department has no previous knowledge of crystal reports they will need training in order to start using it
  • It would be great to have objects integrated on the reports
Score 3 out of 10
Vetted Review
Verified User
Review Source
  • Page formatting.
  • Query generation.
  • Capturing requests at runtime.
  • Connecting to the database is complex and error-prone.
  • Scripting is done in Visual Basic for Applications, and can be hard to debug.
  • Changing the database underneath it can lead to problems getting back in sync.
September 03, 2019

SAP Crystal is a life saver

Score 9 out of 10
Vetted Review
Verified User
Review Source
  • SAP Crystal is easy to use and easy to learn it makes pulling data out of Viewpoint easy and quick.
  • SAP Crystal has a ton of strengths when comparing weaknesses. One of its strengths is the speed of it. It pulls data super quickly.
  • SAP Crystal has a little room for improvement in combining data tables and making it a little less confusing.
Frank Hunt | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Seamless parsing of data across different data sources.
  • Ability to create sub-records and drill-down feature for granular data analysis.
  • Complex queries or SQl statements are done in seconds.
  • The export of reports to Excel is very cumbersome and the results are difficult to format.
  • The design of reports and the graphical features (e.g. charts) feel quite rigid.
  • The learning curve for a non-programmer is incredibly steep, making Crystal a specialty tool.
Rohit Narang | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • 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.
  • It is not very user-friendly for learning as during designs and debugging the error decryption is tedious and hard to figure out.
  • When using sub-reports embedded in the main reports for different views of the same data sourced from multiple tables, this makes the process crazy slow. This is annoying and needs severe improvements.
  • The visual capabilities need to seriously catch up with respect to market competitors. Security is also a concern at times while accessing data.
February 27, 2019

Review Of Crystal Reports

Score 7 out of 10
Vetted Review
Verified User
Review Source
  • SAP Crystal Reports has great 3rd party support that extends its out of the box capabilities
  • SAP Crystal Reports can connect and use almost any data type
  • Crystal Reports connects to all ODBC or OLEDB data sources. You can also connect to older mdb files and even allows you to get data from windows file folders
  • Crystal Reports charting engine is ok but compared to some other visualization products available it is behind the times.
  • Crystal Reports uses a proprietary format for its data storage, using an open format (like XML) would be much better
  • You cannot add add a structured table object to the page layout, you can only use lines and boxes
Jane Kabochi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Customer support is available 24/7 helping new users embrace and learn how to use the software efficiently.
  • The reports generated are usually in many formats from formulas, cross-tabs and sub-reports thereby helping us understand our data.
  • Can generate reports from data obtained from any virtual source
  • The one-time fee paid per user is a bit high and may discourage small and mid-sized companies with many users not to acquire the software.
  • A stable internet connection is required for the software to function well.
  • There is no free trial plan of the software and it ought to be available to help in piloting purposes.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Merge and log data very easily.
  • User interface is good.
  • Different types of fonts and graphs and charts to analyse data easily.
  • Hard to learn. It took a lot of time to learn this software.
  • Database used as a source is quite difficult. We always have to contact technical team for that.