Crystal Reports is a great reporting tool
Janet Fawcett | TrustRadius Reviewer
July 31, 2018

Crystal Reports is a great reporting tool

Score 10 out of 10
Vetted Review
Verified User
Review Source

Software Version

SAP Crystal Reports

Overall Satisfaction with SAP Crystal

We use Crystal Reports across our whole organization. We first were introduced to Crystal when we implemented our ERP system, EFI Monarch, because they had designed a report library of reports they had written for their ERP system using Crystal Reports. Their report library allowed us to create our own Crystal Reports and add them to the library. I love Crystal Reports. It saves us so much time when specific information is requested across our many databases (DB2, SQL, Progress, Excel spreadsheets, XML data, Lotus Notes databases, etc). I haven't found any database that wasn't compatible with Crystal Reports.
  • It allows you to connect to virtually any data source. I have used it to write reports using data from DB2, SQL, Progress, Excel spreadsheets, XML data, Access, and Lotus Notes databases. You can also join different database types together in one report.
  • The drag and drop layout makes it easy to design your report and easy to select data fields to add to your report.
  • When creating a report the Standard Report Creation Wizard walks you through each step needed to create the report and will layout the report for you.
  • There is a wealth of online answers if you have a question about how to do something specific in Crystal Reports.
  • It would be nice if there was a way to search your .rpt files for a specific field or table using a normal search engine. There are secondary tools available for purchase but it would be nice if there were a way to do this without additional purchase.
  • When I first started using Crystal Reports the learning curve was steep. That being said I had never used a reporting tool before. I think if you are familiar with reporting tools the learning curve would not be as steep.
  • If you do happen to get an error message they are sometimes very cryptic and require internet searches to figure out what exactly is wrong.
As I said before I never used a reporting tool before Crystal Reports but I have since used SSRS. Crystal Reports blows SSRS out of the water. The reports look nicer and it was easier, faster, and better to create a report in Crystal Reports. Prior to using Crystal Reports I wrote reports by coding them using RPG on the iSeries. I could never go back to doing that.
I have used Crystal Reports to access data from DB2, SQL Server, Progress database, Excel spreadsheets, XML data, and Lotus Notes databases. Crystal Reports makes it easy to included data from multiple sources in one report. Sometimes the report performance takes a hit when linking several data sources but I keep finding ways to improve the performance the more I use Crystal Reports.
Crystal Reports by itself doesn't have a good distribution and security functions. at least none that I'm aware of. We recently purchased RePORTAL software to distribute our reports via an internal web page. It allows us to set up report security based on Active Directory users and has a way to schedule and distribute reports via email. It has worked great for our needs.
I have recommended Crystal Reports many times to colleagues. It works well with any database structure I've written reports against. I have done a few charts with Crystal and they look amazing. I think the only problem many have with it is the learning curve but that can be overcome with a few online tutorials. There is a wealth of information on the internet. Most colleagues have grown to love Crystal Reports.

SAP Crystal Feature Ratings

Pixel Perfect reports
Customizable dashboards
Report Formatting Templates
Drill-down analysis
Formatting capabilities
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
Publish to Web
Publish to PDF
Location Analytics / Geographic Visualization
Not Rated