Crystal enables presentable canned reports and offers scheduling
Rohit Narang | TrustRadius Reviewer
April 04, 2019

Crystal enables presentable canned reports and offers scheduling

Score 7 out of 10
Vetted Review
Verified User
Review Source

Software Version

SAP Crystal Reports

Overall Satisfaction with SAP Crystal

We use Crystal reports in our credit risk reporting function within the IFRS9 accounting standard to pick up specific delinquency reports at a customer level which needs to feed into disclosures on a quarterly basis. The idea is to receive canned reports by monitoring the amortization profile of customers and which goes as a feed to risk managers in creating early warning list by using specific credit utilization behavior.
  • Great visualization for static format & precise tasks: For presentation to senior management /ex-co/vendors where concise decisions need to be made, Crystal is a nice choice to slide data into presentable views.
  • Diverse data source connect: We have used it to write reports using data from DB2, SQL, Progress, Excel spreadsheets, XML data, Access, and Lotus Notes databases. It can also be used to join different database types together in one report.
  • It uses the "recurring bands" structure for page layout which is efficient and fungible for generating different types of reports. Crystal doesn't require that we set up a metadata layer before creating reports and provides direct access to tables and dimensions.
  • It is not very user-friendly for learning as during designs and debugging the error decryption is tedious and hard to figure out.
  • When using sub-reports embedded in the main reports for different views of the same data sourced from multiple tables, this makes the process crazy slow. This is annoying and needs severe improvements.
  • The visual capabilities need to seriously catch up with respect to market competitors. Security is also a concern at times while accessing data.
  • 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.
It connects with a wide variety of sources ranging from the Lotus Notes database, OLE DB and also supports Java for integration with various modules. It's versatile in itself.
For management reporting functions, certain specifics of formatting are very unique and a strength of the tool. They can sometimes be a pain as well due to the fact that it doesn't identify the same field from multiple tables on account of formatting variances.
We can share data in the .pdf format with users, which is helpful and we need to upgrade to the server version for mobile access of the same.
Our requirements were static in nature and we had a bias for SAP due to the availability of skilled in-house resources.
With department's organizations having precise and periodic (fixed data/views) requirements, it turns out to be a great tool for doing BAU (business as usual) reporting. During agile environments, where bespoke cuts of data are required or frequent changes are the need of the hour, the effort and skills going into designing reports is a serious trade-off since the availability of skilled resources are limited to other market BI tools.

SAP Crystal Feature Ratings

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