What is most valuable?
It can gather data from many sources and consolidate that data.
It is easy to get quick results, but also allows you to create more in-depth reports.
It contains a relational database that allows you to join tables from different tables in the same report.
It can export to Excel, text files, or PDF and many other formats.
A non-IT person can create some reports, and an IT person can take it much further.
If you have Crystal Reports, it can import Excel files that were made in Excel 2003, files with a .xls file extension and file format. It does not yet recognize files with a .xlsx file extension, which would be from Excel 2007, 2010, 2013 or 2016. With Access files, Crystal Reports can import databases with a .mdb format, but not the newer format if .accdb.
This was true as of Crystal Reports 2013. They may have changed it since
How has it helped my organization?
I have used it with several clients to create complex reports that required multiple data sources and complex relationships.
What needs improvement?
They need to make it work with new file formats for Excel and Access. It also needs to be more compatible with other data sources.
For how long have I used the solution?
I have been using Crystal Reports for over 10 years, and this version for about two years.
What was my experience with deployment of the solution?
I have seen integration with SAP , and it seems pretty seamless. There are versions of Crystal Reports that come embedded with other software programs, like Peachtree, etc. I would recommend that you upgrade to the full version so you can take advantage of some of the features.
What do I think about the stability of the solution?
I've experienced no issues with performance.
What do I think about the scalability of the solution?
I have the single user edition.
How are customer service and technical support?
Their support is top notch, although you may have to pay for it.
Which solution did I use previously and why did I switch?
I created many reports using Access. Crystal reports is similar, but more robust.
How was the initial setup?
I have the single user version, and had no problems.
What about the implementation team?
What other advice do I have?
It's a great product that works with many data sources. I highly recommend it.