SAP Crystal Reviews

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

Do you work for this company? Manage this listing

TrustRadius Top Rated for 2019

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (76-100 of 121)

Josel Harrison profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
Crystal Reports is a robust reporting software program that is relatively easy to use once you have a good understanding of the product. It has a variety of capabilities in reporting the data that is queried against existing databases. Once the reports are written they can be provided to various users in the agency who then only need to re-query the data or request and update based on a specific time period.
Read Josel Harrison's full review
Sheila Seal profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

7
You can merge data from different databases but unless you know sql you cannot change data types on the joins. You can refresh real time and it is great from a visual perspective
Read Sheila Seal's full review
Calvin Harris profile photo
September 09, 2016

SAP Crystal Server Review

Score 7 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Merging data from different data sources is fairly straight forward and same with real time reporting. We have more issues with exporting the results to various formats since different clients want different things (e.g. can not export directly into PowerPoint).
Read Calvin Harris's full review
Chris Jensen profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
I've connected to Access, SQL Server, Progress SQL, Oracle and other ODBC data sources. I've also connected to Excel spreadsheets to pull data from those. There are literally dozens of different data sources it can connect to, just about anything really.
Read Chris Jensen's full review
Craig Nash profile photo
Score 3 out of 10
Vetted Review
Verified User
Review Source

Data Integration

2
Crystal Reports has a wide range of connectivity, but provides a lot of headaches, as it is inherently difficult to edit once the report has been created, requiring you to edit the entire report, like editing a document with HTML or pure source code. Once you try to change the original data, problems tend to arise with tables being dropped and moved at random. These can all be fixed, but the fact that they require a fix really puts me off.
Read Craig Nash's full review
Nathan Patrick Taylor profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Crystal Reports can connect to numerous data sources. A fews year ago, we even connected it to a state-of-the-art data warehouse platform that was still in beta from the vendor. With the correct drivers installed, Crystal Reports had no problem connecting to the database. One limitation I'm unsure of is NOSQL or big data sources. I see the SAP Lumira (a different kind of reporting tool similar to Tableau) can connect to big data source. With the correct drivers, it's possible Crystal Report can also.

Crystal Reports can take data from multiple, disparate data sources. For example, if you had a SQL Server database, MySQL database, and flat files it could read from all three in a single report.
Read Nathan Patrick Taylor's full review
Douglas Barbin profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

10
Crystal Reports supports a wide range of data sources, and usually, minimal configuration is required to get things "up and running". I have not tried merging data from disparate sources, although that is certainly an interesting feature that it supports. Overall, it has met our needs without any major issues.
Read Douglas Barbin's full review
Nicole Frigo profile photo
September 15, 2014

Crystal Decisions

Score 8 out of 10
Vetted Review
Verified User
Review Source

Data Integration

9
Real Time is great. It refreshed in seconds and is only dependent on the refresh of your database. If you have transaction data going through, you will be able to see this immediately. There was some confusion when windows was upgraded to mostly 64 bit as the installation needed to be on both ODBC drives. Switching between data sources was really quick and easy, just need to set up DSN connections to various sources. without dictionaries not as user friendly for the average user.
Read Nicole Frigo's full review
No photo available
Score 5 out of 10
Vetted Review
Verified User
Review Source

Data Integration

8
Crystal allows connections to just about any type of data source, including SQL Server, Oracle, Excel spreadsheets, Microsoft Access, and even flat files. In addition, queries can be built inside of Crystal to combine different databases and tables into what is required for a custom report to function properly. The data is easily refreshed as well.
Read this authenticated review

Feature Scorecard Summary

Pixel Perfect reports (101)
8.5
Customizable dashboards (88)
7.8
Report Formatting Templates (106)
8.0
Drill-down analysis (107)
7.4
Formatting capabilities (123)
8.4
Integration with R or other statistical packages (56)
7.5
Report sharing and collaboration (108)
7.8
Publish to Web (81)
7.8
Publish to PDF (121)
8.9
Report Versioning (84)
7.6
Report Delivery Scheduling (86)
8.1
Delivery to Remote Servers (41)
7.9
Pre-built visualization formats (heatmaps, scatter plots etc.) (51)
7.6
Location Analytics / Geographic Visualization (68)
7.1
Predictive Analytics (42)
7.7
Multi-User Support (named login) (73)
7.8
Role-Based Security Model (71)
7.7
Multiple Access Permission Levels (Create, Read, Delete) (71)
7.5
Single Sign-On (SSO) (30)
7.8
Responsive Design for Web Access (54)
7.5
Dedicated iOS Application (38)
6.7
Dedicated Android Application (34)
6.9
Dashboard / Report / Visualization Interactivity on Mobile (49)
7.4
REST API (8)
7.4
Javascript API (27)
7.0
iFrames (8)
7.1
Java API (27)
7.0
Themeable User Interface (UI) (30)
6.9
Customizable Platform (Open Source) (24)
6.6

About 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. According to the vendor SAP Crystal Reports is a robust production reporting tool, that turns 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
Does not have featureAdministration via Windows App
Does not have featureAdministration via MacOS App
Has featureAdministration via Web Interface
Has featureLive Connection to External Data
Has featureSnapshot of External Data
Does not have featureIn-memory data model
Has featureOLAP (Pre-processed cube representation)
Has featureROLAP (SQL-layer querying)
Has featureMulti-Data Source Reporting (Blending)
Has featureData warehouse / dictionary layer
Does not have featureETL Capability
Does not have featureETL Scheduler
Supported Data Sources Features
Has featureMS Excel Workbooks
Has featureText Files (CSV, etc)
Has featureOracle
Has featureMS SQL Server
Has featureIBM DB2
Has featurePostgres
Has featureMySQL
Has featureODBC
Does not have featureCloudera Hadoop
Does not have featureHortonworks Hadoop
Has featureEMC Greenplum
Does not have featureIBM Netezza
Has featureHP Vertica
Does not have featureParAccel
Has featureSAP Hana
Has featureTeradata
Does not have featureSage 500
Has featureSalesforce
Has featureSAP
Does not have featureGoogle Analytics
BI Standard Reporting Features
Has featurePixel Perfect reports
Has featureCustomizable dashboards
Has featureReport Formatting Templates
Ad-hoc Reporting Features
Has featureDrill-down analysis
Has featureFormatting capabilities
Does not have featurePredictive modeling
Has featureIntegration with R or other statistical packages
Has featureReport sharing and collaboration
Report Output and Scheduling Features
Has featurePublish to Web
Has featurePublish to PDF
Has featureOutput Raw Supporting Data
Has featureReport Versioning
Has featureReport Delivery Scheduling
Has featureDelivery to Remote Servers
Data Discovery and Visualization Features
Does not have featurePre-built visualization formats (heatmaps, scatter plots etc.)
Has featureLocation Analytics / Geographic Visualization
Does not have featurePredictive Analytics
Does not have featureSupport for Machine Learning models
Does not have featurePattern Recognition and Data Mining
Does not have featureIntegration with R or other statistical packages
Access Control and Security Features
Has featureMulti-User Support (named login)
Has featureRole-Based Security Model
Has featureMultiple Access Permission Levels (Create, Read, Delete)
Has featureReport-Level Access Control
Has featureTable-Level Access Control (BI-layer)
Has featureField-Level Access Control (BI-layer)
Has featureSingle Sign-On (SSO)
Mobile Capabilities Features
Has featureResponsive Design for Web Access
Has featureDedicated iOS Application
Has featureDedicated Android Application
Has featureDashboard / Report / Visualization Interactivity on Mobile
Application Program Interfaces (APIs) / Embedding Features
Does not have featureREST API
Has featureJavascript API
Does not have featureiFrames
Has featureJava API
Has featureThemeable User Interface (UI)
Has featureCustomizable Platform (Open Source)
Additional Features
Has featurePowerful options to deliver key insights and a clearer picture of the business to decision makers
Has featureBroader connectivity to diverse data sources to provide real-time operational reports that empower employees to make day-to-day business decisions
Has featureFlexible, customizable report design to give customers and partners the information they need in the reporting format of their choice

SAP Crystal Screenshots

SAP Crystal Videos (4)

SAP Crystal Downloadables

SAP Crystal Integrations

SAP Crystal Reports for Visual Studio, SAP Crystal Reports for Eclipse

SAP Crystal Competitors

Pricing

  • Has featureFree Trial Available?Yes
  • Has featureFree or Freemium Version Available?Yes
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?Optional
EditionPricing DetailsTerms
SAP Crystal Reports 2016 - Full version$495per user
SAP Crystal Server 2016 1 NUL$869per named user
SAP Crystal Server 2016 5 CAL$8,744per 5 concurrent users
SAP Crystal Reports Viewer 2016$0per user
SAP Crystal Reports 2016 - Upgrade$295per user

* 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.

SAP Crystal Support Options

 Free VersionPaid Version
Live Chat
Email
Forum/Community
FAQ/Knowledgebase
Social Media
Video Tutorials / Webinar
Phone

SAP Crystal Technical Details

Deployment Types:On-premise
Operating Systems: Windows, Linux
Mobile Application:Apple iOS, Android
Supported Languages: English, 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