SAP Crystal Reports Software

4.32 / 5 (118) FrontRunners®

About SAP Crystal Reports


SAP Crystal Reports is a business intelligence (BI) on-premise solution for Windows that is suitable for small to midsize businesses across multiple industries. It combines the reporting capabilities of SAP Crystal Reports with the secured delivery mechanisms of SAP Crystal Server. It also allows report consumption on mobile apps for iOS and Android.

The system offers the ability to write customized reports from many data sources and visualize data in reports, dashboards and scorecards, display KPIs and other metrics related to project or departmental performance.

It offers multi-language support for up to 28 languages. Languages covered include English, French, German, Japanese, Spanish, Italian, Dutch, Russian and Simplified Chinese.

SAP Crystal Reports is priced per user. Help and support are provided through an online community forum, email and phone.



Read More

Supported Operating System(s):

Windows 7, Windows 8, Windows 10

118 Reviews of SAP Crystal Reports

Average User Ratings

Overall

4.32 / 5 stars

Ease-of-use

3.5

Value for money

4.0

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(52)

4 stars

(49)

3 stars

(17)

2 stars

(0)

1 stars

(0)

Likelihood to Recommend

Not likely

Very likely

Filter reviews by:

Sort by: Most Helpful | Most Recent

Showing 1-20 of 118 reviews

Do you use this product?Write a review

October 2018

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

3.0

Value for money

4.0

Functionality

5.0

October 2018

Dynamic and Interactive Reports

If I need dynamic, impressive reports, SAP crystal reports is very flexible and offers many solutions to various requirements

Pros

1. Depending on the report requirements, Crystal reports has great capabilities to allow you to create all kinds of reports. You can place images, forms etc using OLE.
2. It allows a user to define multiple data sources, making it flexible when transferring to different platforms.
3. It allows a user to conditionally suppress sections within the report which enables certain parameters to be checked in certain sections of the report.
4. It enables the drill-down feature which allows the final user of the report to drill down further within a report to view more specific details.
5. It can do complex queries and allows a user to incorporate SQL statements in a flexible manner.
6. A user can create sub-reports, group selections and easily format various sections of the report in order to achieve different requirements.
7. It allows format parameters to be used easily and flexibly e.g. one item on the report can be bolded and displayed in italics due to specified parameters.
8. Supports different types of data sources e.g. HANA, MS SQL, Excel etc

Cons

1. For a new user, it might be challenging to create new reports and one might not fully utilize most of the features.
2. Graphical features such as charts are not as enhanced as in other reporting tools.
3. Development of complex reports might take a bit of time depending on the user's experience level
4. When you export a report created with crystal reports to excel, there is a lot of distortion depending on the excel format. It will take a lot of trial and error and eventually, the data on the report is hard to edit on excel.
5. It might crash often after a software update.

November 2015

David from Tyler Technologies


Ease-of-use

5.0

Customer support

4.0

Functionality

5.0

November 2015

Crystal Reports Helps Companies See Through To Their Business Info

Pros

Learning Crystal Reports is only part of the educational process for learning Business Intelligence Reporting. You need to have the fundamental ability to become familiar with how a business operates, how it uses information. You need to be able to translate a company's requirements for managing and and acting on information to the technical organization and structure of its data systems. To be a successful report developer you need to be able to speak both languages. There are some great resources out there for Crystal Reports professionals, such my own Crystal Reports group on LinkedIn, where developers meet and share ideas as well as where employers and recruiters come to find them. There is also the Crystal Reports Users Group Crystal Users group, both hosted by Yahoo Groups, which have been serving and supporting Crystal Reports professionals for over a decade. Plus many web sites, online tutorials, video tutorials, skills training and more. Just don't forget that there are two sides to Business Intelligence Reporting - and Crystal Reports is only one of them.

Crystal Reports is a highly featured and flexible business intelligence tool that has been around for over 2 decades. It is database independent, meaning you can develop reports against just about any database or structured file format, from Microsoft SQL and Oracle, to flat file to text file to spreadsheets to anything for which you can access via ODBC, DAO, XML, OLE DB, JDBC and many more protocols. Crystal Reports integrates seamlessly into SAP BusinessObjects Enterprise products as well as other SAP data management products. Reports can link tables internally within the design template, or developers can build their own external SQL Queries, views, stored procedures or universes and build their reports off those data sources. Crystal also allows developers to script their custom own SQL-based query in the Database Editor. And if your data source changes, Crystal provides tools for mapping your existing report over to the new similarly structured data source. Record selection formulas can help filter out unwanted data to improve the efficiency of report performance.

Crystal Reports has a highly flexible report design editor that features multi-pass linear data processing, allowing analysis to be performed while reading records as while printing records. Data may be grouped or sorted based on raw data or on formulas that can analyze and manipulate record data for customized processing. Crystal Reports allows developers to create virtually any kind of data-based report, from tabular column listings to data-driven letters to charts, cross-tabs, free-form and (pre-printed) form-fitting solutions. Extensive summary functions, running totals, and a rich formula programming language (Crystal also supports Basic syntax) provide unlimited opportunity to manage and manipulate raw data for analysis and presentation to the customer, be it a management report, operations report or customer-facing report. With sub-reports, it is possible to link together tangentially Connected Data sources, expanding the opportunities of publishing relevant information onto a single page or report. Individually formattable multi-section detail, page and group headers and footer sections allow the developer to play with suppression, paging and other formatting options and formulas.

Crystal Reports is a WSIWYG design tool, allowing you to see what you are doing as you do it. Whether you use the the grid or guidelines with the Design Tool, or the size and alignment tools with the Preview Tool, Crystal lets you create the report as you want to see it. You can integrate external images, files, or even BI products, such as Crystal Dashboards (Xelcius). Through the use of parameters, reports can be designed to include user input in the record selection, formatting and operation of the report. Reports can be generated for printing, export to Adobe Acrobat, to Microsoft Excel or many other formats. Crystal can also be easily linked into 3rd party applications through XML, Java, Visual Studio or other APIs. Crystal Reports can also be easily delivered through the Crystal Reports Server or the Business Objects Enterprise Server, providing a hosting platform for both scheduled automation and on-demand report generation.

Cons

For someone experienced in business intelligence, databases or programming, Crystal Reports is relatively intuitive, though it will take time and experience to learn how to fully leverage every feature. There are included tutorials that teach the basics, but real world situations often defy the simplicity of the provided solutions. There are plenty of third-party resources from Yahoo and LinkedIn groups to user support web sites and video, instructional and printed training materials. Crystal is not something that the home user can jump into. The license is relatively expensive and does not include a database server, database or other data source. Licensing for enterprise environments can get pricey quickly. While many employers hire report developers directly, there is a large community of professional report developers who work contracts, either independently or through contract employment agencies. In most cases, the employer provides the licensed Crystal Reports tool, but if a company has only infrequent report development needs, they may expect the consultant to provide their own copy of the software. SAP is really not set up for supporting the individual, however, preferring to engage the company in business-licensed products.

Crystal Reports has incredible flexibility but their are limitations, mostly in formatting. Working with lines and boxes is not as flexible as, say, Microsoft Word. Charts and graphs have many features and options but they can be difficult to try and force your data to conform to the usage requirements. Graphics cannot be edited in-template, and some image formats are not supported (though you can easily convert an image to a supported format). The design tool can have issues with orphaned text at the bottom or the top of a page. While you can include comments in formulas, there is no ability to provide comments to the actual data, static, calculated value or other objects within the report design. Rules applied to the selection and manipulation of data can have unexpected results, leading to manual troubleshooting of report design and database queries. Like any piece of template design software, there are bound to be situations where you want to do something a certain way that is not supported by Crystal Reports, which can lead to frustration. But there are usually ways to think outside of the box to accomplish what you want.

Crystal Reports is getting a little long in the tooth. While still one of the worlds' most popular reporting tools, It hasn't received a major update in many years, while Microsoft's SQL Server Reporting Services as well as open-source and other business intelligence competition products have grown in popularity, and it shows. The user interface and feature set hasn't significantly changed in quite a while. Of course, it was already pretty rich and complete, but it lacks the feel and finish of many current generation software products. There is also no version available for the Apple Mac, which means no support for iOS devices. Some feel that SAP doesn't see the Crystal product line as the best place for its R&D investments, pushing more data analytic based products such as Web Intelligence. I think there is room and demand for both and wish SAP would wow me with an upgrade that would transform Crystal Reports into a new generation of business intelligence reporting that sets the bar for everyone else.

March 2019

Brittany from Construction

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

3.0

Functionality

4.0

March 2019

Crystal Report Review from the company Controller

The most difficult problem to overcome is the necessity to be logged into the database in order to run a report.

Pros

Our industry based software comes with a limited scope of canned reports and Crystal has proven to be a great supplemental reporting program. When our software falls shorts, Crystal offers many solutions. Upper level management, executives, and owning partners love how they can drill down into the finite details the Crystal reports can be built to display. And our data analysts use very detailed reports with minimal formatting exported as excel documents to create a plethora of pivot tables and other analytics including profit margin information and auditing information. I also like that the formulas are more similar to excel then other reporting syntax I have used.

Cons

Anyone who has built a Crystal report from scratch can tell you it can be difficult to link tables and other data source issues can cause major problems with the information. Some of this difficulty comes the complexity associated with the software tables linked to the crystal report data source of course... but I do not think the average user can pick up the syntax very easily. And I have found that advanced formatting and cascading parameters can be a major headache.

March 2019

Raghavendar from Infosys Technologies Limited

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

3.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

March 2019

Picture perfect reporting tool

We use this for some of the reports where user is looking for a particular report but not for data extract. Well, most of the reporting is done on Universe and WebI, based on the need we also use Crystal reporting. We have multiple options for defining the formula, including mathematical and logical functions. We can use advanced data analytics and visualization in the new version but not yet explored by me.

Pros

Crystal report are canned report, formatted report for printing purpose, like Legal reports, they has to be printed in predefined format, with cell size/cell width or logo etc. each and everything is modifiable). This tool is picture perfect reports since each thing is customizable. You can connect to multiple databases and send the free hand SQL for querying the data

Cons

The security implementation is not good. Since query is done without any middle layer like BO universe, report can bring lot of data, no control on data level security etc. Also, the interface is not as good as Web Intelligence or other reporting components. Look and feel while developing is also not very friendly. Lot of adjustment to be made to make a template. Of late there are no much improvements made and it is costly for a customer to get the report created via a development project.

March 2019

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

4.0

Functionality

4.0

March 2019

Powerful and easy to use

I love working with it and when I retire, I am going to come back as a Crystal Reports programmer. :)

Pros

I love how I can take data from our database and present it in a pleasing way for our users. I have been using Crystal Reports for almost 20 years and find it very powerful. I can build a report very quickly and a few simple format changes and make it look professional. I developed a program to run a series of reports with parameters passed from the program. I can do our month end process in minutes instead of running 100 reports one at a time. So it is great for creating a report and easy to add to a .NET program to be run automagically. Pretty cool!

Cons

It can be time consuming to build a complex report with lots of formulas. Not a fault of the software. Just the process is long at times when you have over 100 formulas. It would be nice if there was a feature where you could easily clone a formula and then change it quickly for each situation. Although, maybe in a newer version of CR this might be possible.

February 2018

Marsha from eGov Jamaica Ltd.

Company Size: 201-500 employees

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

February 2018

I like that it customize the different reports we generate daily and multiple users can view them

I like that crystal report is able to customize the different reports we generate daily and multiple users can view them. Also, I like that it allows for multiple users to feed and draw data from these reports. I like that its all centralized in one place with the flexibility of expanding or changing if need be. I am impresses with how data can be formatted with the various options and once you are trained it actually easy to use.

Pros

I like that crystal report is able to customize the different reports we generate daily and multiple users can view them. Also, I like that it allows for multiple users to feed and draw data from these reports. I like that its all centralized in one place with the flexibility of expanding or changing if need be. I am impresses with how data can be formatted with the various options and once you are trained it actually easy to use.

Cons

This tool takes time to become acquainted with, fortunate for us some of our guys were already familiar with the tool and was willing to train the other team members. The upside to this tool is once you are trained it is a good tool to use.

December 2016

Mike from VHDA

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

3.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

December 2016

A bit of a learning curve, but a life saver!

My job involves working with similar data that is housed in different databases, both internal and external. Before Crystal Reports, I would pull several reports out of several databases, bring the data into Excel and run pivot tables, vlookups, etc... to be able to see the relations in the data. With Crystal Reports, as long as I have a common data field, (such as a part number) I can combine data from several different sources and run reports based on the related data. This is a much easier method. For example, I am now able to run a single report that shows our current orders, the current inventory available to fill those orders and based on that, make a single order to our vendor for re-stocking. This used to take at least 2 hours out of my day... now it is quick enough that I run the report twice a day and very rarely have stock outtages.

Pros

The ability to pull and parse data from several different data sources and report on the related data sets

Cons

The learning curve is a bit steep, but once you set up a report, it can be re-run easily any time and as often as you need, quickly and cleanly.

December 2018

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

3.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

December 2018

A wonderful tool for the generation of reports.

I use SAP Crystal Reports to generate different statistics about the problems and requests in the technological area of ​​the company, allowing to customize each report based on the characteristics and hierarchy of the end users.

Pros

What I like most about this software is that it allows you to quickly transform any data source into interactive and relevant content for different users. Also integrates design, modification and visualization capabilities in different types of applications such as .NET, Java or COM and
allows end users to access and interact with reports through different means such as Web portals, mobile devices and Microsoft Office documents. In general, it is an incredible tool for the generation of different types of reports, providing the option to widely customize each of them.

Cons

Given the amount of tools and options that it offers, its handling is sometimes a bit complex, especially for users with little technical knowledge.

February 2018

Luca from Intralot Italia S.p.A.- Gamenet Group

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

February 2018

A perfect and particular reporting system

Knowledge on reporting systems and different point of view on several platforms.

Pros

Excellent reporting system, highly functional especially when combined with the use of SAP Universities (which are in practice a kind of DWH).
I particularly like for his different conception of reporting with the areas subdivided into sections as "groups" that comes out a bit from the concept of a paged sheet but different reasons must be made keeping in mind how the group behaves. Surely one of the best reporting systems. Excellent pixel perfect.

Cons

Just its peculiarity of having the sections divided and divisible by "groups", makes the drafting of the report a little more complicated, but it is something that is understood and you can easily manage it by working day after day. For the rest I think he has no particular points to the detriment of his duty and does it well.

August 2018

Erue from San Francisco City College

Company Size: 201-500 employees

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

5.0

Functionality

5.0

August 2018

Really effective and professional

This is the traditional reporting tool that is used in many financial organizations. I have used SAP Crystal Reports 12 in my organization. We can design highly formatted reports using this tool. It can connect to multiple data sources such as ODBC, OLE DB etc. We can create reports with different formats such as pdf, csv, txt, xls, etc. We can also create html, xml reports. The price of this tool is also cheap. We can create detailed graphics, instrument panels.

Pros

There are some written exercises based on SAP Crystal Report that facilitate learning.
the integration with the different IDE of development are optimized.
it is compatible with the most popular database administrators, MYSQL, SQLSERVER, POSTGRESQL. and more...
The designer of Crystal is fantastic, drag and drop add-ons to create your report.

Cons

I had a lot of problems and spent a lot of time trying to adjust the space between the rows. I hope that in the future, SAP Crytal Report will make it easier.
should block the sizes of pre-established and blocked sheets to avoid leaving the margins.

August 2016

Paul from 21st Century Programming

Company Size: 2-10 employees

Review Source: Capterra


Ease-of-use

4.0

V