Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Senior Data Analyst at a healthcare company with 1,001-5,000 employees
Vendor
The ability to create reports via the GUI is a valuable feature

What is most valuable?

The ability to create reports via the GUI with click and drag at the table level as well as from SQL via Command objects.

For how long have I used the solution?

I have used CR with a number of different db types (Oracle, SQL Server, etc.) for a number of different data types (health care, accounting, manufacturing, etc.). 

I have been using the app since version 5 in 1996. I was a certified instructor and implementation specialist on CR and BOE (and its predecessors Seagate Info) via the developers from 1997 through 2002.

Which solution did I use previously and why did I switch?

What little I have seen of other products I would select CR and BOE but I am not the decision maker of the organization..

What other advice do I have?

There are many suggestions but the first would be to develop a template of how you would like your reports to look. Consistent layout helps users focus on the data rather than figuring out how to view a report, e.g., this report shows drill down links blue and underlined like the Web, but the other shows them in boxes with a note at the top that you can click on boxed items for more info.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user456381 - PeerSpot reviewer
Consultant on Health Care Reporting and Analytics at a tech company with 501-1,000 employees
Vendor
In my experience, the strongest feature of Crystal Reports is in developing automated business intelligence reports which convert raw data into actionable business intelligence.

What is most valuable?

In my experience, the strongest feature of Crystal Reports is in developing automated business intelligence reports which convert raw data into actionable business intelligence.

How has it helped my organization?

In 2000 when I joined a manufacturing firm, most of the accounting data was exported into spreadsheets, consequently extensive time was spent on preparing reports and making timely decisions. In 2002, I initiated utilization of the MS Access Reporting tool by importing Excel files into Access. I created reports about all accounts including customers, suppliers, employees and entities related to the business. I soon realized that MS Access reporting is a good start, but it became hard to integrate data from variety of sources, in addition to an additional step of importing data into MS Access. On further research, I found Crystal Reports to address the issue of data integration, and hence utilized Crystal Reports 8-9. I found Crystal Reports to be an excellent dedicated reporting tool, and I invested time in taking advanced training.

What needs improvement?

I would like to have horizontal paging like crosstabs.

For how long have I used the solution?

I have been using Crystal Reports for the last 12 Years.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

This is a mature product and so I have not came across any major stability issues.

What do I think about the scalability of the solution?

It's been able to scale for our needs.

Which solution did I use previously and why did I switch?

Previously, I used MS Excel, then Access before moving on to Crystal Reports.

How was the initial setup?

It was fairly straightforward.

What about the implementation team?

We performed an in-house implementation and this should be fine for all cases.

What other advice do I have?

I found Crystal Reports to address the issue of data integration, and hence utilized Crystal Reports 2013. Crystal Reports is an excellent dedicated reporting tool, and I invested time into advanced training. I would say Crystal Reports is great tool, and has been in the business intelligence arena for a while. Hence, it's an excellent choice.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SAP Crystals
November 2024
Learn what your peers think about SAP Crystal Reports. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,067 professionals have used our research since 2012.
PeerSpot user
Manager of Architecture/Design at a government with 501-1,000 employees
Real User
It's easy to use and it provides good connectivity to various databases. The visualization needs work as the look is not very appealing.

Valuable Features

What I like about it is that it's easy to use and it provides good connectivity to various databases.

Improvements to My Organization

We use it for all of our operational and tabular reports.

Room for Improvement

The visualization needs work as the look is not very appealing. The UI definitely needs some updating.

Also, SAP charges an annual maintenance fee. Be careful, too, with the license model. I'd suggest that because Crystal Reports is for tabular reports, use another product for true BI.

Use of Solution

I've used it for 10 years.

Deployment Issues

There have been no issues with the deployment.

Stability Issues

Some reports take a while to be generated.

Scalability Issues

We've had no issues scaling it.

Customer Service and Technical Support

In my experience, the level of technical support is not good. They are, however, able to resolve issues in a timely fashion.

Initial Setup

The initial setup was easy and straightforward.

Implementation Team

Some reports come out-of-the-box within our applications and we built some others. So you could say that implementation was a combination of SAP's product as well as our in-house team's efforts.

Pricing, Setup Cost and Licensing

Be careful with the annual maintenance fee, and get CPU based report access. Be careful with the license model. This product is for tabular reports, but for true BI reporting, use another product.

Other Solutions Considered

We are retiring Crystal Reports soon, and it will be replaced by IBI WebFOCUS and SQL Server Reporting Services.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user463368 - PeerSpot reviewer
Crystal Reports Developer at a tech services company with 10,001+ employees
Real User
For the basics, the product is easy to learn.

What needs improvement?

Eliminate the reserved space in Page Footer section.

Find an easier way to utilize the Database > Links feature, or allow the ability to alter the selection SQL. Crystal Reports makes too many assumptions, causing odd results, which can sometimes be corrected by altering the SQL or changing the links (providing you understand the link options).

For how long have I used the solution?

Since 2011.

What was my experience with deployment of the solution?

I did not encounter any deployment, stability or scalability issues.

Which solution did I use previously and why did I switch?

I was not part of the search/decision making process. I don’t know why the organization’s developers/decision makers chose this product to present their reports. They continue to use it, so it must be satisfying their needs.

Which other solutions did I evaluate?

I have not yet used other products, so I have nothing to compare against.

What other advice do I have?

The product is easy to learn for the basics. However, some features are difficult to learn and use (e.g., cross-tab tables). Documentation is minimal.

The product makes assumptions with table/view/stored procedure links, which can create unpredictable results.

The option settings (especially font settings) are global. I work with many customers who use different fonts and sizes. It is annoying to have to reset the option settings based on which client report I’m working.

The page footer reserves space; if you use a page footer on only the first page, it wastes real estate on subsequent pages.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Developer at a government with 1,001-5,000 employees
Vendor
We're able to select and format multiple data fields and labels, which is valuable because there are times when a group of fields needs a smaller font or to be moved together across the page.

Valuable Features

One of the most valuable features is the ability to precisely place data fields and labels on the report canvas either in Design Mode or Preview Mode. This is a great feature because when a report page requires many data fields, each item needs to be as close as possible.

Another valuable feature is the ability to select and format or align multiple data fields and labels because there are times when a group of fields needs a smaller font or to be moved together across the page.

Room for Improvement

There are two items that would improve the product. One is a simple text search across all formulas, and the other is a debug mode that would allow the developer to step line-by-line through long or complicated formulas.

Use of Solution

I've been using it for 17 years.

Deployment Issues

We have had no issues with the deployment.

Stability Issues

There have been no issues with the stability.

Scalability Issues

There have been no issues scaling it for our needs.

Customer Service and Technical Support

For the most part, technical support is responsive and helpful. However, the majority of technical support is in another country which can cause problems scheduling a contact time and can hamper verbal communication.

Initial Setup

The initial setup is straightforward. However, on a couple of occasions the licensing was corrupted and required uninstalling and reinstalling the software.

Implementation Team

Implementation was done by our in-house team.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user163092 - PeerSpot reviewer
Senior Reporting Consultant at a tech services company with 51-200 employees
Consultant
Third party add-on needed for maps and gauges but straightforward setup

What is most valuable?

Pixel perfect static reporting.

What needs improvement?

Bought and sold many times and newer product releases do not seem to offer much improvement. Maps and gauges are pretty much worthless and you need to buy a third party add-on.

For how long have I used the solution?

17 years

What was my experience with deployment of the solution?

None encountered.

What do I think about the stability of the solution?

Early versions use to be very prone to crashing. Much better in the 2013 version

What do I think about the scalability of the solution?

None encountered.

How are customer service and technical support?

Customer Service:

You try not to contact SAP, just Google search for answers to your problems.

Technical Support:

You try not to contact SAP, just Google search for answers to your problems.

Which solution did I use previously and why did I switch?

Back in the days (90s), Quick Reports that came with Delphi. Crystal Reports had more functionality hence the switch.

How was the initial setup?

Straightforward set-up.

What about the implementation team?

In-house implementation.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user446715 - PeerSpot reviewer
Consultant Commercial & ShipConnect / VRS at a computer software company with 501-1,000 employees
Vendor
I develop reports for customers, for an ERP system that collects a lot of data, but has very few standard reports

What is most valuable?

The ease of making simple reports. The facts that many people use it, hence a lot of expertise can be found on the internet and trainings are available.

How has it helped my organization?

I develop reports for customers, for an ERP system that collects a lot of data, but has very few standard reports. Customers use the reports for making decisions and negotiations.

What needs improvement?

  • Sub-reports in sub-reports
  • Making graphs is very cumbersome
  • Exporting to Excel
  • Using Stored procedures
  • Complex SQL Queries

For how long have I used the solution?

I've used Crystal Reports in general for about 20 years, and v2008 for about six years.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

We have had no issues with the stability.

What do I think about the scalability of the solution?

We haven't needed to scale it.

How is customer service and technical support?

I wasn't aware of there being any.

How was the initial setup?

It's very straightforward.

What about the implementation team?

I have only installed the developer version, and that can anyone do with it’s eyes closed.

What was our ROI?

The training of users can be more expensive. User training can take two to five days, and in addition, the user needs to understand the database, the tables, and where to get the data.

What's my experience with pricing, setup cost, and licensing?

The training of users can be more expensive. User taining can take two to five days, and in addition, the user needs to understand the database, the tables, and where to get the data.

What other advice do I have?

It does what it does have to do, but seems development has stuck for several years now. Many things are not possible either. Complex queries are impossible, you need to make SQL statements. Sub report in a sub report is impossible.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user628023 - PeerSpot reviewer
Microsoft Nokia Service Manager at a comms service provider with 501-1,000 employees
Vendor
It is easy to use and it connects to the major databases.

What is most valuable?

It is easy to use and it connects to the major databases.

How has it helped my organization?

It provides trusted business information for decisions and operations management.

What needs improvement?

The sales, operations, and IT areas could use improvement.

For how long have I used the solution?

I have been using Crystal Reports for 20 years, since 1997.

What was my experience with deployment of the solution?

I have had no major issues with deployment.

What do I think about the stability of the solution?

I have had no issues with the stability.

What do I think about the scalability of the solution?

This is a simple but powerful reporting tool. I don’t have scalability issues for more than 100 users.

How are customer service and technical support?

Customer Service:

I would give customer service a rating of 4.5/5.

Technical Support:

Technical support is good. I would give technical support a rating of 4.5/5.

Which solution did I use previously and why did I switch?

I used Excel, but that was a long time ago when the BI tools were very basic.

What about the implementation team?

I have implemented both with a vendor team and in-house. My level is expert.

What was our ROI?

The ROI depends on your use. In the first implementation, it was very productive with sales increases and time reduction.

What's my experience with pricing, setup cost, and licensing?

Today, I only use a standalone license.

What other advice do I have?

If you are looking for a cheap operational tool, the Crystal Reports family is the correct decision.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SAP Crystal Reports Report and get advice and tips from experienced pros sharing their opinions.
Updated: November 2024
Product Categories
Reporting
Buyer's Guide
Download our free SAP Crystal Reports Report and get advice and tips from experienced pros sharing their opinions.