Crystal Delivers Thousands of Reports Per Week
February 18, 2020

Crystal Delivers Thousands of Reports Per Week

Gene Baker | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Software Version

SAP Crystal Reports

Overall Satisfaction with SAP Crystal

We use Crystal Reports to generate over 200 standard reports for various data topics from our record-keeping system. These reports can be for the business or for our customers. We generate thousands of reports each week that are then delivered to our clients. Crystal is used within our organization. The enterprise has a variety of reporting tools in use. We have been using Crystal Reports for over 18 years on our team.
  • 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?
  • Low cost to code and deploy a new report.
  • Low cost of ownership.
We found that Crystal was a little more intuitive to our team members than the other products. All of the products were excellent choices but we liked the ability to code stored procedures to gather our data. While each product has very similar features, we went with Crystal given how long it has been on the market, the ease of finding developers skilled in Crystal and the fact that we've used it since 2003. We have evaluated many products over the years as we look for new features but always stay with Crystal. Another key feature was how we can schedule reports and generate and deliver them to our customers. Each week we generate thousands of reports without issue.
We have used this as our reporting solution for 18 years. We have reviewed other technologies like Tableau and Jasper Reports. We found Crystal the easiest to use for our environment. We create all of our reports in the same format using a stored procedure to gather the result set. We do this so that we can control the SQL and validate the performance. The downside to this is we can't do the drag and drop reports and have to rely on the assistance of a SQL Developer to code the stored procedure for us. The upside is once the proc is coded and tested, it is tuned for performance so that the reports execute efficiently without causing negative issues on the system for transactional queries.

SAP Crystal Feature Ratings

Pixel Perfect reports
9
Customizable dashboards
9
Report Formatting Templates
10
Drill-down analysis
7
Formatting capabilities
10
Integration with R or other statistical packages
8
Report sharing and collaboration
10
Publish to Web
10
Publish to PDF
10
Report Versioning
9
Report Delivery Scheduling
10
Delivery to Remote Servers
10
Location Analytics / Geographic Visualization
Not Rated
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
10
Single Sign-On (SSO)
8
Responsive Design for Web Access
10
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
10
Javascript API
8
Java API
8
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated