Try our new research platform with insights from 80,000+ expert users
it_user224157 - PeerSpot reviewer
AVP at a financial services firm with 10,001+ employees
Real User
We can extend it to complicated reports with interactive charts and enhance the understanding of business models.

What is most valuable?

  • Rapid report development, since the design interface makes coding easier.
  • We can extend it to complicated reports with interactive charts and enhance the understanding of business models.
  • Exposes a report object model that can interact with other controls on the ASP.NET Web form.
  • It can be programmed to export the reports into widely used formats such as PDF, Word, Excel, HTML, and RTF.

How has it helped my organization?

We are using it for pixel perfect reporting, and that is why it is better than other reporting tools.

What needs improvement?

It needs better integration with Hadoop as well as enhancements for more analytical usage.

Also, a secured end user cannot modify data if the report is generated via Crystal Reports. It can only be done if the data is in HTML format.

What was my experience with deployment of the solution?

We have had no issues with the deployment.

Buyer's Guide
SAP Crystals
December 2024
Learn what your peers think about SAP Crystal Reports. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,265 professionals have used our research since 2012.

What do I think about the stability of the solution?

We have had no issues with its stability.

What do I think about the scalability of the solution?

There have been no issues scaling it for our needs.

What other advice do I have?

Analyze it first as to whether it is a good fit for your needs. There are other good products available for analytical needs, which Crystal Reports doesn't yet provide.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user431850 - PeerSpot reviewer
Director at a tech consulting company with 51-200 employees
Real User
The ability to set parameters, especially the cascading parameters, is the most valuable features for us.

What is most valuable?

The ability to set parameters, especially the cascading parameters, is the most valuable features for us.

How has it helped my organization?

We provide solutions to other organizations, so invariably the end reports save our clients time and, of course, money.

The example that comes to mind was where a medical client had a monthly utilization report that took 14 days to complete manually as it involved using MS Access and Excel. After the report was created in Crystal Reports, it took less than 30 seconds to run and it also highlighted data entry errors that could be fixed more efficiently, so a suite of error/exception reports had to be created also.

What needs improvement?

The linking feature between tables has always been a bit buggy, which is not good because it is really the core of ensuring that the returned data is correct. If one tries to enforce the links created as per the underlying data source, invariably it falls over and results in an error message.

The cascade parameters limit of 1000 records, which although can be increased via the registry, if you have admin rights, can result in report performance issues. Isn't there a better way of doing this?

Being able to have formulas that make up the description for value parameters, potentially on the fly, and then being able to display the parameter value and/or description selected by the user on the report, would be great also

I actually wrote a blog post of the things I wished Crystal Reports could do here: http://maximumimpactsolutions.co.uk/blog/comments.asp?bd=110. Some of the things may have ready been implemented.

For how long have I used the solution?

I've been using it for four years.

What was my experience with deployment of the solution?

We have had no issues with deployment.

What do I think about the stability of the solution?

There have been no issues with the stability.

What do I think about the scalability of the solution?

We have had no issues scaling it.

How are customer service and technical support?

I've never needed to use customer service/technical support.

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

I've been using this since v7.

How was the initial setup?

It's straightforward.

What about the implementation team?

Implemented it in-house, and there was nothing complex about it.

What was our ROI?

Our ROI on Crystal Reports is well over 1000%, as we offer both training and consultancy solutions to our clients.

What other advice do I have?

Crystal Reports is a great little reporting tool for a myriad of data sources that provides the user a nice user-friendly GUI, which means that your report creation can be achieved quickly.

Disclosure: My company has a business relationship with this vendor other than being a customer: We offer training and consulting of Crystal Reports for our clients.
PeerSpot user
Buyer's Guide
SAP Crystals
December 2024
Learn what your peers think about SAP Crystal Reports. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,265 professionals have used our research since 2012.
it_user7515 - PeerSpot reviewer
Owner at a tech consulting company with 51-200 employees
Consultant
Crystal Reports on SAP Mobile BI


It seems like every month SAP is unleashing new functionality for its Mobile BI app. Explorer, Web Intelligence and recently Dashboards have all made their way into the BI app and seem to work better, look nicer and perform faster then on the desktop! The mobile versions are not only slick and easy to use, they are also very easy to deploy to. For webi, all it takes to turn the report to mobile ready is assignment to a category (as is the case for Dashboards and Crystal), Explorer is there by default, and Dashboard can be saved as Mobile when exported to the repository. It’s that simple. Well, almost… While the product does allow developers to deploy content to the BI app very easily, the challenges of the design are still there, with a twist. Data issues, business logic complexities, real estate constraints, functionality gaps, all of the same challenges that make BI content development difficult for any device are applicable, with the additional challenge of new constraints related to mobile device usage and functionality that is “ramping up”. And while Webi, Explorer and Dashboards are “sexy”, dashing and elegant tools, I set out to try the capabilities of good old Crystal Reports on the BI App, and as always when it comes to Crystal, I was not disappointed!

While Crystal on the iPad lacks some of the Explorer and Webi “swooshiness” and feels a bit “boxy”, it certainly provides much more flexibility in design, navigation and layout capabilities. And since images can be used to enhance its look and feel, Crystal can be made to look as modern as any. Unlike in Webi on the mobile BI app where the report design is limited to simplistic blocks that get converted automagically to the stunning iPad design, Crystal reports will render EXACTLY the way you design them on the desktop. So you can layout the screen any which way you like, which can be very important for some design situations. Crystal unlimited data connectivity also makes it a great choice for directly connecting to any data source with ease. So your crystal report on the iPad will connect to anything you need to, from Universes to any RDBMS, web service, and beyond. The group tree functionality is also enables on the iPad and provides slick and easy way to navigate large hierarchies on the iPad, prompts, work as well and drill downs are all there in their interactive glory. You can paginate using the page number icons, or simply swipe left to move to the next page. Nice.

The image I posted is from a Crystal Report I created with sales data and hierarchy, and I hope it provides a good example of what Crystal actually looks like on the iPad.

So, all in all, Crystal can be an important companion for your mobile BI content deployment, and after more than two decades of reign over the enterprise reporting realm can still help address use cases and reporting scenarios that other more modern tools cannot.

Disclosure: My company is a SAP partner

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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_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
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
Buyer's Guide
Download our free SAP Crystal Reports Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 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.