Crystal -- Good software if it is still 2005
September 15, 2019

Crystal -- Good software if it is still 2005

Anonymous | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User

Software Version

SAP Crystal Reports

Overall Satisfaction with SAP Crystal

Many custom reports are developed by our IT department to serve our various departments. At this time, it is largely used for legacy reporting and for personalized, highly formatted emails. Many of our older reports are written using Crystal Reports. We are gradually phasing out those reports and moving to SSRS.
  • Page formatting.
  • Query generation.
  • Capturing requests at runtime.
  • Connecting to the database is complex and error-prone.
  • Scripting is done in Visual Basic for Applications, and can be hard to debug.
  • Changing the database underneath it can lead to problems getting back in sync.
  • It was a state of the art product in 2000, with minimal investment ever since.
  • We are moving to more agile, cost-effective solutions.
As I stated in the previous question, the SQL Server reporting engine provides necessary scheduling services to allow for employee self-service. It also supports granular security, based upon active directory, to control who can see which report. SAP Crystal is still superior when it comes time to produce a highly formatted report. If it is any time after 2005, I would skip Crystal.
It can connect decently to an ODBC data source. If you need to create a highly formatted report, with a lot of graphics and careful field placement, it can do that well. On the other hand, if you are generating a run of the mill business report, you can do better with SQL Server Reporting Server.

SAP Crystal Feature Ratings

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