What users are saying about
Top Rated
119 Ratings

SAP Crystal

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
422 Ratings
Top Rated
119 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

SAP Crystal

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

Add comparison

Likelihood to Recommend

Alteryx Analytics

Alteryx can do so much more than I use it for, so I believe the only case where Alteryx wouldn't be needed is when a department/team had a full development team to prep data pre-analysis or already has a central data store fully stood up and standardized. Alteryx works extremely well with a multitude of BI and database solutions and would be a great fit for any team trying to speed up the typical daily grind of data prep and ETL so their analytics and data team can be more agile, accurate, and automated.
Joe Root profile photo

SAP Crystal

SAP Crystal Report is well suited for those companies that posses ERP systems based on SAP, if you're willing to learn how to use the tool and set goals to master the reporting features this is the right tool for you and your company. You can develop and deliver amazing results with the reports. However, if you're looking for an intuitive tool that allows you to set up fast track to achieving decent reports with integration capability try to use BI tools that allow you to use a cross-reference from diverse sources.
Victor Arana profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.9
SAP Crystal
8.0
Pixel Perfect reports
Alteryx Analytics
8.0
SAP Crystal
8.0
Customizable dashboards
Alteryx Analytics
6.7
SAP Crystal
7.7
Report Formatting Templates
Alteryx Analytics
9.0
SAP Crystal
8.2

Ad-hoc Reporting

Alteryx Analytics
8.5
SAP Crystal
7.8
Drill-down analysis
Alteryx Analytics
8.3
SAP Crystal
7.7
Formatting capabilities
Alteryx Analytics
8.2
SAP Crystal
8.5
Integration with R or other statistical packages
Alteryx Analytics
9.5
SAP Crystal
7.0
Report sharing and collaboration
Alteryx Analytics
8.0
SAP Crystal
7.9

Report Output and Scheduling

Alteryx Analytics
8.7
SAP Crystal
8.2
Publish to Web
Alteryx Analytics
8.2
SAP Crystal
8.1
Publish to PDF
Alteryx Analytics
8.5
SAP Crystal
8.6
Report Versioning
Alteryx Analytics
9.0
SAP Crystal
7.9
Report Delivery Scheduling
Alteryx Analytics
8.9
SAP Crystal
8.2
Delivery to Remote Servers
Alteryx Analytics
SAP Crystal
8.3

Data Discovery and Visualization

Alteryx Analytics
7.9
SAP Crystal
7.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
SAP Crystal
7.5
Location Analytics / Geographic Visualization
Alteryx Analytics
7.5
SAP Crystal
7.3
Predictive Analytics
Alteryx Analytics
8.3
SAP Crystal
7.7

Access Control and Security

Alteryx Analytics
8.3
SAP Crystal
7.8
Multi-User Support (named login)
Alteryx Analytics
8.0
SAP Crystal
7.9
Role-Based Security Model
Alteryx Analytics
8.0
SAP Crystal
7.6
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
SAP Crystal
7.8
Single Sign-On (SSO)
Alteryx Analytics
SAP Crystal
7.8

Mobile Capabilities

Alteryx Analytics
4.0
SAP Crystal
7.5
Responsive Design for Web Access
Alteryx Analytics
4.0
SAP Crystal
7.7
Dedicated iOS Application
Alteryx Analytics
SAP Crystal
7.5
Dedicated Android Application
Alteryx Analytics
SAP Crystal
7.5
Dashboard / Report / Visualization Interactivity on Mobile
Alteryx Analytics
SAP Crystal
7.5

Application Program Interfaces (APIs) / Embedding

Alteryx Analytics
SAP Crystal
7.5
REST API
Alteryx Analytics
SAP Crystal
7.5
Javascript API
Alteryx Analytics
SAP Crystal
7.8
iFrames
Alteryx Analytics
SAP Crystal
7.0
Java API
Alteryx Analytics
SAP Crystal
8.0
Themeable User Interface (UI)
Alteryx Analytics
SAP Crystal
7.3
Customizable Platform (Open Source)
Alteryx Analytics
SAP Crystal
7.0

Pros

  • Data ingestion: Alteryx is capable of connecting with a multitude of data sources from SQL databases to cloud-hosted solutions like Salesforce, Tableau, or Google Analytics. Also supports OleDB & ODBC connections.
  • Dynamic data munging: Alteryx has a great variety of processing tools to clean and prep data including: dedupe, formulas, joins, union, sort... Performing these functions really quickly on even moderately equipped laptops or desktops. It's dynamic in that it can easily handle changes in data by allowing extra columns to flow through.
  • Macros: have a process that you are consistently running in separate workflows? Build a macro, be it a batch or iterative, Alteryx can do it. I've built 40-50 macros and use at least 4+ in every workflow I design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.
Joe Root profile photo
  • Crystal allows you to connect to virtually any type of data that is available.
  • Crystal Reports has a rich ecosystem of third party products that extend its capabilities. My site lists dozens of tools that provide viewing, scheduling and managing reports, along with formula UFLs that can let your report interact with your operating system and other applications and services.
  • Crystal, especially the more recent versions, let you create virtually any desired layout with the ability to locate objects anywhere and move them based on conditions in the data.
  • Crystal uses the classic "recurring bands" structure for page layout. I find this efficient and very flexible for generating different types of reports.
  • Crystal doesn't require that you set up a meta data layer before creating reports. It gives you direct access to your tables and fields.
  • The interface in Crystal Reports, while sophisticated, is still primarily designed for end users rather than a programmers.
Ken Hamady profile photo

Cons

  • I've had issues with the scheduler tool getting frozen or stuck in previous versions. For about the last 2-3 months the latest software version has been much more reliable. Previously I had to restart the Alteryx service on my machine at least once a week, which meant my workflows weren't running while the service had been stuck and data wasn't moving.
  • Some of the connectors, like the Tableau Online connector, should become supported by Alteryx. The online community is fantastic and has created a ton of useful macros and it would be great if Alteryx would adopt, support, and enhance some of the most widely used and useful.
Joe Root profile photo
  • It would be nice to have sometime of functionality that would better detect an improper linking of two or more tables. Sometimes I don't know that I have an improper link until after I run a report and realize data records are repeating.
  • Sometimes the pass through of formula values from multiple sub reports to a main report can be in error based on the placement of the sub reports in relation to each other. It would be great to have functionality that warns you about those issues.
  • There should be more intellisense provided in the formula interface when creating conditional statements.
Thomas Harty profile photo

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
Mark Frisch profile photo
SAP Crystal10.0
Based on 19 answers
I've never seen its equal. Other tools either require a complex meta layer, require IT level users or don't have the distribution capabilities that are affordable for all companies. It is hard indeed to be all things to all people but when it comes to reporting, Crystal is just that.
Charlotte Craig profile photo

Usability

Alteryx Analytics10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Nick Lensing profile photo
SAP Crystal7.9
Based on 22 answers
Overall Crystal Reports meets ours needs. It's fairly usable by our technical support team and does not require too much additional training. Overall it is a software that you can learn by reading a good "Dummies" book on. End users will be surprised at how nice the outputs look as well.
Cody Martin profile photo

Reliability and Availability

Alteryx Analytics10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman profile photo
SAP Crystal8.0
Based on 1 answer
No answer on this topic is available.

Support

Alteryx Analytics9.9
Based on 2 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Nick Lensing profile photo
SAP Crystal5.8
Based on 15 answers
Most support can be obtained through forums and other users. Typically this provides a better experiencing that contacting SAP directly.
Cody Martin profile photo

Implementation

Alteryx Analytics10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman profile photo
SAP Crystal8.6
Based on 14 answers
Document your process completely.
Jeff Hieber profile photo

Alternatives Considered

Alteryx's UI is fantastic insomuch that training can really be self-driven, albeit with several Google searches a day and visits to the Alteryx community. The other solutions we looked at were much less intuitive and not nearly as flexible, automated, and didn't give you the capability to watch the data be changed through every step of the process like Alteryx can do through browses and data samples.
Joe Root profile photo
I cannot compare Crystal Reports with other tools because I have not used anything like it. Most of my experience, when Crystal Reports was not available, was to use the default reporting capabilities of the accounting software and then doing a data dump in excel and then using excel to format and create customize grouping of data.
Thomas Harty profile photo

Return on Investment

  • Alteryx does an excellent job of integrating consumer and spatial data to calculate and visualize things like locations within a certain drive-time radius.
  • For visualization purposes I had to move the data to excel for some decent graphs.
  • It can become very expensive.
No photo available
  • It has allowed us to focus over 80 percent of the labor spent in the past on report distribution on other areas of the business.
  • It provides us with a tool to meet all of our internal and external report demands
  • Allows us 24/7/365 ability to get data to users without staffing for these jobs to get done.
Jeff Hieber profile photo

Pricing Details

Alteryx Analytics

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No
Alteryx Analytics Editions & Modules
Alteryx Analytics
On-premise Edition
Alteryx Designer
$3,9951
Alteryx Designer with Spatial
$12,9951
Alteryx Designer with Data
$29,9951
Alteryx Server
$45,0002
1. per user, per year
2. per server, per year
SaaS Edition
Alteryx Analytics Gallery
$1,5001
1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

Alteryx Analytics More Information

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
SAP Crystal
Edition
SAP Crystal Reports 2016 - Full version
$4951
SAP Crystal Server 2016 1 NUL
$8692
SAP Crystal Server 2016 5 CAL
$8,7443
SAP Crystal Reports Viewer 2016
$04
SAP Crystal Reports 2016 - Upgrade
$2954
1. per user
2. per named user
3. per 5 concurrent users
4. per user
Additional Pricing Details
* 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 More Information