Analytic Solver vs. SAP Crystal

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Analytic Solver
Score 7.0 out of 10
N/A
Frontline Systems Analytic Solver is an Excel add-on for performing data mining, and predictive analytics from within Microsoft Excel.N/A
SAP Crystal
Score 7.4 out of 10
N/A
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.
$295
per single user license
Pricing
Analytic SolverSAP Crystal
Editions & Modules
No answers on this topic
Upgrade Version to SAP Crystal Reports 2020
$295
per single user license
SAP Crystal Reports 2020 64-Bit
$495
per single user license
SAP Crystal Reports 2016 32-Bit
$495
per single user license
SAP Crystal Server 2020 1 NUL
$869
per user license + first year maintenance to be added
SAP Crystal Server 2020 5 CAL
$8,744
5 concurrent users + first year maintenance to be added
Offerings
Pricing Offerings
Analytic SolverSAP Crystal
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details* SAP Crystal Reports 2020 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2020 - 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 2020 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2020, 1 NUL includes 1 license of: SAP Crystal Reports 2020 - SAP Crystal Server 2020. * As an add-on to SAP Crystal Server 2020 1 NUL, SAP Crystal Server 2020 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.
More Pricing Information
Community Pulse
Analytic SolverSAP Crystal
Features
Analytic SolverSAP Crystal
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
7.8
124 Ratings
5% below category average
Pixel Perfect reports00 Ratings8.0113 Ratings
Customizable dashboards00 Ratings7.0100 Ratings
Report Formatting Templates00 Ratings8.4117 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
8.3
136 Ratings
3% above category average
Drill-down analysis00 Ratings9.0117 Ratings
Formatting capabilities00 Ratings8.7135 Ratings
Integration with R or other statistical packages00 Ratings7.064 Ratings
Report sharing and collaboration00 Ratings8.7120 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
8.8
136 Ratings
7% above category average
Publish to Web00 Ratings9.091 Ratings
Publish to PDF00 Ratings9.3133 Ratings
Report Versioning00 Ratings8.094 Ratings
Report Delivery Scheduling00 Ratings9.097 Ratings
Delivery to Remote Servers00 Ratings8.554 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
7.6
89 Ratings
5% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings7.650 Ratings
Location Analytics / Geographic Visualization00 Ratings7.576 Ratings
Predictive Analytics00 Ratings7.841 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
8.6
88 Ratings
1% above category average
Multi-User Support (named login)00 Ratings8.581 Ratings
Role-Based Security Model00 Ratings8.580 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.580 Ratings
Report-Level Access Control00 Ratings8.53 Ratings
Single Sign-On (SSO)00 Ratings9.040 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
6.7
65 Ratings
15% below category average
Responsive Design for Web Access00 Ratings6.363 Ratings
Mobile Application00 Ratings6.046 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings6.360 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Analytic Solver
-
Ratings
SAP Crystal
7.9
45 Ratings
2% above category average
REST API00 Ratings7.48 Ratings
Javascript API00 Ratings8.437 Ratings
iFrames00 Ratings7.18 Ratings
Java API00 Ratings8.437 Ratings
Themeable User Interface (UI)00 Ratings7.539 Ratings
Customizable Platform (Open Source)00 Ratings8.433 Ratings
Best Alternatives
Analytic SolverSAP Crystal
Small Businesses
IBM SPSS Statistics
IBM SPSS Statistics
Score 8.2 out of 10
Yellowfin
Yellowfin
Score 8.7 out of 10
Medium-sized Companies
Posit
Posit
Score 10.0 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Posit
Posit
Score 10.0 out of 10
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Analytic SolverSAP Crystal
Likelihood to Recommend
9.0
(2 ratings)
7.0
(159 ratings)
Likelihood to Renew
-
(0 ratings)
10.0
(19 ratings)
Usability
-
(0 ratings)
7.3
(31 ratings)
Availability
-
(0 ratings)
8.0
(1 ratings)
Performance
-
(0 ratings)
8.0
(1 ratings)
Support Rating
-
(0 ratings)
8.6
(21 ratings)
In-Person Training
-
(0 ratings)
10.0
(1 ratings)
Implementation Rating
-
(0 ratings)
8.8
(14 ratings)
Configurability
-
(0 ratings)
8.0
(1 ratings)
Ease of integration
-
(0 ratings)
7.0
(1 ratings)
Product Scalability
-
(0 ratings)
7.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
8.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
7.0
(1 ratings)
User Testimonials
Analytic SolverSAP Crystal
Likelihood to Recommend
Frontline Systems
Based on my limited experience and use, and therefore limited global knowledge of the software, I would recommend it especially if the data that will be used as inputs to the model has previously worked on a spreadsheet such as Excel. I would also recommend it to analyze problems of medium and small size. Given the experience I have had when I have used it with large problems, there have been noticeable decreases in the speed of response (which are not associated with the size of the system of equations involved in the calculation). Excellent for processing linear programming models.
Read full review
SAP
Generation of templated reports is the strong suit of SAP Crystal. Allows users to change formats in templates bases on requirement with minimal effort. Automated report delivery requires the user to be aware of sql which cannot be expected from all users. Should support more document export formats and improve the UI for SAP B1 Users
Read full review
Pros
Frontline Systems
  • Easy to use and learn.
  • Strong optimization platform for business and supply chain problems which can be modeled in Excel
  • It can handle multiple objectives and more than 8000 decision variables in a problem.
  • Lots of tutorial and examples are available to solve the problem
Read full review
SAP
  • 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.
Read full review
Cons
Frontline Systems
  • On the few occasions when I have used it to deal with problems of optimization of relatively large parameters (with a large number of restrictions and decision variables), the program has been slower, not substantially but slower, than programs such as the WinQsb, even when the latter runs on 32-bit machines and not 64. That has caught my attention, even though it is not a real problem for the uses I give to the program.
  • Given my partial function as a university professor, it has been much more effective and practical to use other software, due to the limited options that the educational license associated with the software has.
Read full review
SAP
  • 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.
Read full review
Likelihood to Renew
Frontline Systems
No answers on this topic
SAP
We have been using this product for so many years and it has truly become a cornerstone to our business processes when it comes to developing and distributing information via reports. We currently have over 500 reports developed to date over about 30 systems and that will continue to grow as user needs change.
Read full review
Usability
Frontline Systems
No answers on this topic
SAP
Crystal is very robust, but not always easy to use. It create wonderful looking reports, and so deserves a high rating. However, I have to take a couple of points off for the simple fact that I cannot hand it to a user and expect them to be able to do development with it.
Read full review
Support Rating
Frontline Systems
No answers on this topic
SAP
The support community can be difficult to navigate. I've also run into issues with my login. The SAP system has a bizarre mechanism for validating users that requires users to have what is called an S-ID. A basic ID may not give you access to all the features in the portal. The limitation may include not being able to perform a simple task like downloading patches and updates. This isn't a big deal for single user license but for teams it can be a pain.
Read full review
In-Person Training
Frontline Systems
No answers on this topic
SAP
Trainer was patient and thorough in going through the basics and willing to answer questions by email after the initial training
Read full review
Implementation Rating
Frontline Systems
No answers on this topic
SAP
Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
Read full review
Alternatives Considered
Frontline Systems
We believe in building the models in Excel. A limitation with Excel is that Excel Solver can not take more than 200 decision variables with multiple constraints. It is cheap in terms of license and maintenance fees against other softwares which are available in the market.
Read full review
SAP
Crystal reports is useful in case we want to import data from data base . We can write queries in it but Google Charts require to be implemented in our application using code so crystal reports is better than Google Charts.
Read full review
Return on Investment
Frontline Systems
  • - It has allowed finding ways to optimize (minimizing costs or times) the field processes involved in various projects.
  • It has even allowed, in specific cases where it was used for that purpose, to optimize the allocation of resources (people) to work in different jobs that present weekly variations of the activity that these people must perform.
  • It has allowed the sensitivity analysis of projects to changes in the decision variables related to them, which, and in very dynamic and changing environments, resulted in substantial decreases in money losses.
Read full review
SAP
  • It is a decent buy for specific departments in terms of reporting capabilities but updates and cost (frequent) demands are higher with the benefits offered.
  • So long as the requirements are not ever changing, with scheduling functionality, it's a handsome tool.
Read full review
ScreenShots

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 reports