SAP Crystal Reports Software


 

Relied upon by organizations worldwide, Crystal Reports is one of the most widely utilized report writing tools on the market today. Crystal Reports allows companies to quickly and easily access critical information in their databases with queries and then present that information in any number of drillable, multi-page reports: invoices, financial statements, order forms and more. This robust business intelligence tool can be integrated into a number of mission-critical applications, allowing users to access a variety of data sources for complete reporting.

Crystal Reports can be utilized by organizations in just about any industry - accounting, education, HR, manufacturing and real estate, just to name a few. It's often integrated into a larger business intelligence strategy like the SAP BusinessObjects stack. It can be either locally installed or offered in the SaaS model.

Crystal Reports helps organizations design dynamic reports that can be connected to almost any data source. These reports can pull from databases for operation reporting. The solution can create detailed reports representing customer invoices and can support barcodes. Financial reporting such as income statements and revenue reports is quick and pixel perfect.

With the ability to design professional reports that can include interactive charts and what-if scenario models, and then disseminate these reports via the Web, email, in PDF or even embedded into enterprise systems, Crystal Reports gives organizations the leverage to make fast, accurate strategic decisions.

For organizations looking to design interactive, informative reports and then share the information, Crystal Reports is an industry-leading, agile report writing tool.

 

Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000

7 Reviews of SAP Crystal Reports

Showing 1-7 of 7

 

from Glidewell Specialties Foundry Co, Inc.
Specialty: Manufacturing
Number of employees: 101 to 500 employees Employees number: 101 to 500 employees

Crystal Reports is an excellent tool for pulling and reporting data.

Ease-of-use

Functionality

Product Quality

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support

N/A

Likes Best

Crystal has allowed us to pull data from our system in a much more meaningful way than with our old methods. It also allows us to customize what individuals see on reports, to tailor them to their liking. With our old processes we had a report we would send to a salesman that required around 6 different reports molded in to one within an excel file. This whole process was eliminated and we were able to produce the same results using Crystal.

Likes Least

Crystal is pretty intuitive but for the average person it will take some learning to be able to use the software to its full potential. I would say it has a medium to high learning curve. There are also a few annoyances where some windows force attention and will not let you click anything else until you finish that window.

Recommendations

First, make sure any software you want to integrate with Crystal is compatible. It can tap in to a lot of things but not everything.

 

from CRA
Specialty: Government
Number of employees: More than 1,001 employees Employees number: More than 1,001 employees

Director of ECD

Ease-of-use

Functionality

Product Quality

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support

N/A

Likes Best

Its's easy to navigate and simple easy to understand

Likes Least

updates can cause delays and can have impact on delivert of progduct.

Recommendations

none as it's all good when you have been using same product overf the years

 

from Day and Zimmermann
Specialty: Construction / Contracting
Number of employees: More than 1,001 employees Employees number: More than 1,001 employees

Very Versatile on data report, Graphs/Charts can use some improvement

Ease-of-use

Functionality

Product Quality

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support

N/A

Likes Best

Allow user to bring data in from many different types of data sources. SQL / HANA / Excel / Access / Universe etc.
Very easy to use, all user need to do drag and drop fields on report.

Likes Least

Some of the graphs have their limitation. Some functions still need improvement. The graphs and charts are somewhat customizable, but functions like changing the size of the markers on line chart or number formatting on different axis are not working properly.

Recommendations

When you first start using it, it is better to bring in a small sets of data in to try out different functionalities, grouping, sorting, running totals and many others functions to ensure that you have a fairly good understanding on how each function acts and reacts on different type of data.

 

from Intralot
Specialty: Software / Technology
Number of employees: 101 to 500 employees Employees number: 101 to 500 employees

A professional reporting software

Ease-of-use

Functionality

Product Quality

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support

N/A

Likes Best

I used this software during my previous work experience.
Among the different reporstica tool I used I believe that Crystal Reports is one of the best in terms of usability.
The things I appreciate most of this software is the dynamic division of sections into groups and subgroups, the ability to easily modify the report output even from the view in the preview tab, and editable grid.

Likes Least

Incorporating some reports in web pages I had some problems like misalignment etc.
The designer should be a bit 'improved in terms of appearance and functionality, also the graphs should be more attractive.

Recommendations

There are various reporting solutions on the market, some even integrated (i.e. reporting on sqlserver), if you want to buy crystal report also evaluated depending on your needs and your budget, the entire solution business objects that also includes Excelsius for dashboards, universes for data warehousing, the management console etc ..

 

from Prominence Health
Specialty: Insurance
Number of employees: 101 to 500 employees Employees number: 101 to 500 employees

Still the Champ

Ease-of-use

Functionality

Product Quality

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support

N/A

Likes Best

There's a lot to like about Crystal Reports, I don't think anything else out there has the flexibility and versatility in terms of data display and formatting. Its strength is paper formatting, it's like desktop publishing software for databases.

Likes Least

There are some weaknesses, export to Excel has never been perfect (although it can get pretty close if you use vertical guides to identify where columns should go). It is so paper-oriented that if you need to make a large layout you have to find a matching paper size -- challenging if you don't have a large-format printer. And the expense of course, not for the Crystal software, but the enterprise server so that others may view and run the reports. Very spendy.

Recommendations

Think about how important it is to have beautifully formatted reports vs. just dumping data into Excel for the user to manipulate and format themselves. So many users just want the latter, particularly folks in Finance who are usually pretty strong spreadsheet users. For those folks Crystal might not be the best query tool just to pull data out of the database. But if you want reports that are presentation ready, then CR is the best.

 

from Day & Zimmermann
Specialty: Energy & Utilities
Number of employees: More than 1,001 employees Employees number: More than 1,001 employees

Crystal Reports - Lots of good but requires patience

Ease-of-use

Functionality

Product Quality

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support

N/A

Likes Best

Crystal Reports allows for standardized reporting across our company. It leverages multiple data sources and allows us to provide consistent reporting to all of our external clients and internal stakeholders.

Likes Least

There are some small nagging issues with Crystal Reports that I wish they would enhance. The graphing leaves a lot to be desired and at times there are small formatting issues that can be dealt with but our an annoyance.

Recommendations

Have patience. It can be a little rough when just starting out, but it is rewarding in the end.

 

from Tyler Technologies
Specialty: Software / Technology
Number of employees: More than 1,001 employees Employees number: More than 1,001 employees

Crystal Reports Helps Companies See Through To Their Business Info

Ease-of-use

Functionality

Product Quality

Customer Support

Ease-of-use
Ease-of-use
Functionality
Functionality
Product Quality
Quality
Support
Likes Best

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.

Likes Least

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.

Recommendations

I have made my career off Crystal Reports. Business Intelligence is a niche area of Information Technology that combines technical knowledge and an understanding of how a company uses information. Crystal Reports is the most solid, flexible and reliable business intelligence tool I have worked with, allowing me to work on projects in a variety of markets and industries, from the financial to educational, to telecommunications to governmental. Understanding how to use Crystal Reports as part of a Business Intelligence career gives you the tools you need to better connect businesses to their data, deliver quality and productive solutions, and allow you the report developer to build the experience and skills to build a reputable career in the high demand world of Business Intelligence Reporting.

 
 
Write a Review