What users are saying about

9 Spokes

2 Ratings

SAP Crystal

412 Ratings

9 Spokes

2 Ratings
Score 8 out of 101

SAP Crystal

412 Ratings
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

9 Spokes

Good for letting your investors, employees and others know at a glance how your company is doing. The interface is clean and organized well. I just wish more of the app's functionality was available for testing and implementation. "Coming soon" is not really encouraging when we already have been waiting for a year or more.
No photo available

SAP Crystal

I'm biased because I've used Crystal for so long and there's very little that I've needed to do that I haven't been able to do with it.I particularly like being able to write my own queries instead of having Crystal write them for me. With this feature, I've been able to do some very complex reports this way. I could have done most of these reports by linking tables together in Crystal and using Crystal's filter and suppression features, but putting the logic in the query means that Crystal is processing less data so the report is faster.Crystal is less suited for showing graphs, unless you just need very simple line or bar graphs. It's also not really suited to doing ad-hoc reporting for most users because it is more technical than some other reporting tools.
Dell Stinnett-Christy profile photo

Feature Rating Comparison

BI Standard Reporting

9 Spokes
9.0
SAP Crystal
8.0
Customizable dashboards
9 Spokes
9.0
SAP Crystal
7.6
Pixel Perfect reports
9 Spokes
SAP Crystal
8.1
Report Formatting Templates
9 Spokes
SAP Crystal
8.2

Ad-hoc Reporting

9 Spokes
7.0
SAP Crystal
7.8
Drill-down analysis
9 Spokes
7.0
SAP Crystal
7.9
Formatting capabilities
9 Spokes
SAP Crystal
8.5
Integration with R or other statistical packages
9 Spokes
SAP Crystal
7.1
Report sharing and collaboration
9 Spokes
SAP Crystal
7.9

Data Discovery and Visualization

9 Spokes
10.0
SAP Crystal
7.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
9 Spokes
10.0
SAP Crystal
7.5
Location Analytics / Geographic Visualization
9 Spokes
SAP Crystal
7.4
Predictive Analytics
9 Spokes
SAP Crystal
7.7

Access Control and Security

9 Spokes
9.0
SAP Crystal
7.6
Multi-User Support (named login)
9 Spokes
9.0
SAP Crystal
7.7
Role-Based Security Model
9 Spokes
SAP Crystal
7.5
Multiple Access Permission Levels (Create, Read, Delete)
9 Spokes
SAP Crystal
7.6
Single Sign-On (SSO)
9 Spokes
SAP Crystal
7.5

Mobile Capabilities

9 Spokes
8.0
SAP Crystal
7.4
Responsive Design for Web Access
9 Spokes
6.0
SAP Crystal
7.4
Dashboard / Report / Visualization Interactivity on Mobile
9 Spokes
10.0
SAP Crystal
7.3
Dedicated iOS Application
9 Spokes
SAP Crystal
7.4
Dedicated Android Application
9 Spokes
SAP Crystal
7.5

Report Output and Scheduling

9 Spokes
SAP Crystal
8.2
Publish to Web
9 Spokes
SAP Crystal
8.0
Publish to PDF
9 Spokes
SAP Crystal
8.7
Report Versioning
9 Spokes
SAP Crystal
7.7
Report Delivery Scheduling
9 Spokes
SAP Crystal
8.2
Delivery to Remote Servers
9 Spokes
SAP Crystal
8.2

Application Program Interfaces (APIs) / Embedding

9 Spokes
SAP Crystal
7.3
REST API
9 Spokes
SAP Crystal
7.5
Javascript API
9 Spokes
SAP Crystal
7.6
iFrames
9 Spokes
SAP Crystal
7.0
Java API
9 Spokes
SAP Crystal
7.9
Themeable User Interface (UI)
9 Spokes
SAP Crystal
7.1
Customizable Platform (Open Source)
9 Spokes
SAP Crystal
6.9

Pros

  • Grouping several apps in one place for easy viewing.
  • Clean dashboard interface that looks uncluttered when viewing several apps at once.
  • Setting up the apps is a breeze when the platform supports them.
No photo available
  • In addition to linking together tables and views from the database in order to get data into your report, Crystal allows you to write your own SQL queries using an "Command". This feature allows for the use of very complex queries to get data for your reports.
  • Crystal can connect to MANY different types of databases. It has native connections available for a number of them, including Oracle, and will connect to almost anything else using either ODBC or (less common) JDBC.
  • Subreports, when used correctly, are a powerful feature for bringing additional data into a report.
  • There are SDK's available to integrate reporting into either .NET or Java applications and websites.
Dell Stinnett-Christy profile photo

Cons

  • Integration with apps that are listed. Some of them are not supported yet and it seems the wait is taking longer than I'd like.
  • iPhone support. It would be nice to have this in the app store. Not available as of 04/25/2018.
No photo available
  • The option to export to Excel is very picky about report format to get a clean export. Once you know the tricks for setting up a report for this export, it's not hard to do, but it can be very tedious if the report has a lot of elements. This is the way it's been for years and SAP has indicated that it's not something that's going to be changed.
  • Crystal requires that a user knows how the data they're reporting on is configured in the database - it's not really suited for a "casual" user, but for someone with at least some technical skills in relation to databases. This is not something that can or should necessarily be changed, but it is something that potential users need to be aware of.
  • Other than new types of database connections, SAP has indicated that they will not be upgrading any functionality in "classic" Crystal. They instead have chosen to focus on upgrades to Crystal for Enterprise. The problem with that is that it requires the SAP BI Platform - either SAP BusinessObjects or SAP Crystal Reports Server.
  • One of the major things that's not being upgraded is the Charting libraries, which were last updated in the early 2000's, before SAP purchased Crystal. So, Crystal doesn't have newer chart types available.
Dell Stinnett-Christy profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
SAP Crystal10.0
Based on 19 answers
We use what the vendor provides. My choice would be to switch to Cognos because the rest of the organization uses Cognos.
Greg Gurr profile photo

Usability

No score
No answers yet
No answers on this topic
SAP Crystal7.9
Based on 22 answers
If you're a technical user who understands databases, it's pretty easy to get up to speed with Crystal quickly. However, if you're an unsophisticated business user without database knowledge and skills, it's going to be very difficult to use.
Dell Stinnett-Christy profile photo

Support

9 Spokes5.0
Based on 1 answer
Support was helpful in the beginning but no longer needed because I didn't use the software as much. The experience that I did have with support was very friendly but not enough to give a good review. If the support team was called for initial setup, video chat or messenger app was used.
No photo available
SAP Crystal5.9
Based on 15 answers
I've never interacted with it.
Alicia Barevich, bCRE, bCEE profile photo

Implementation

No score
No answers yet
No answers on this topic
SAP Crystal8.6
Based on 14 answers
It was a fairly easy implementation with the small bumps any project might endure. Overall it was an as-expected implementation.
Greg Goss profile photo

Breadth of Deployment

No answers on this topic
It is not widely adopted; Crystal Reports is a niche that is allowed to co-exist with the Cognos corporate standard. If it came up for a vote, Crystal Reports would not be adopted.
Greg Gurr profile photo

Alternatives Considered

I actually chose QuickBooks (currently using) and Method (used for a month) before deciding that 9 Spokes is just good for looking at a few apps in one place. I'll keep checking back with them to see if they have improved. I wouldn't be surprised if 9 Spokes improves their product within the next 6-12 months.
No photo available
Tableau was a great and user-friendly tool to use for a long time; however, it did not manage various users and their security access very well nor did it provide the level of reporting variation that was necessary at my company. SAP Crystal took some legwork, in the beginning, to get set up and at a place where we felt comfortable, but once there we were able to adapt to new reports and new data feeds much faster than with Tableau.
Joseph R. Sweeney profile photo

Collaboration and Sharing

9 Spokes7.0
Based on 1 answer
Access control capabilities are OK. Ease of sharing is great because the app design is made special for that purpose. I haven't dove that far into the app enough to generate reports. Formatting is very flexible because 9 Spokes allows the user to customize how the info is displayed. Security or lack thereof is not a factor for me so I am unable to give feedback on security.
No photo available
SAP Crystal7.1
Based on 101 answers
As mentioned earlier, we have over a dozen vendors that supply us with information, not to mention the various team members that require access to the system to generate reports and draw conclusions from them. As such, being able to customize the feeds and visibility into the system is key and is made much easier through SAP Crystal. Likewise, the reports that we make can have their security adjusted within each one for an even greater level of flexibility.
Joseph R. Sweeney profile photo

Data Integration

9 Spokes5.0
Based on 1 answer
I gave 9 Spokes a five because the range of data sources is minimal. Ease of merging data from disparate sources is pretty good for the ones they do support. I just want to have more apps available for arranging on their nice looking interface. Perhaps next year my review for 9 Spokes will be better than 5
No photo available
SAP Crystal8.2
Based on 105 answers
Crystal Reports can access a wide range of database types and reports can be refreshed and updated instantaneously.
Thomas Harty profile photo

Return on Investment

No answers on this topic
  • Employee Empowerment - Now that our Crystal Reports are written and published, all of our team members have access to run the same reports across the company. Previously, there was only 1 point person in charge of running reports, which took a lot of time away from other job duties.
  • Increased Employee Efficiency - One of the Crystal Reports my company uses has allowed me to take a task that took 3 days to complete and cut the time down to 4 hours. There was a lot of manual data collection and calculations that were done, which has also led to less errors.
  • Accurate real-time data - Since Crystal Reports are very quick to run, we are able to give real time data to our customers rather than maintaining oudated databases in other systems such as Excel.
Shannon Odland profile photo

Pricing Details

9 Spokes

General
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
9 Spokes Editions & Modules
9 Spokes
Additional Pricing Details
9 Spokes is free to use - that’s joining, using the smart dashboard and connecting your apps to it. You'll only pay for any new apps you decide to purchase, but you can trial most of the app recommendations for free! If you want to purchase an app, we'll direct you to the app's website so you can sign up with them. If you sign up to a plan, you'll pay the apps directly and then you can connect the app to your dashboard.

9 Spokes 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
$4951
SAP Crystal Server NUL
$8691
SAP Crystal Server CAL
$8,7442
1. per user
2. per seat
Additional Pricing Details
SAP Crystal Reports Viewer is available for free. It allows static data to be viewed within an SAP Crystal Reports file.

SAP Crystal More Information