SAP Crystal Reports

Crystal Reports Services & Solutions

sap-crystal-reportsCrystal Reports is the world standard for high performance reporting. It is the chosen reporting solution for over 500 major, independent software vendors and it's embedded within leading enterprise application software from Microsoft, SAP, Borland, BEA and IBM.

We provide consultation and services for different versions of Crystal Reports. You can choose the one that best suits your needs below.

Also, if you're looking to maximize your use of Crystal Reports or obtain certifications, you can view our Crystal Reports training.


Versions of Crystal Reports We Specialize In

Crystal Reports

Crystal Reports provides connectivity to virtually any enterprise data source, rich features for building business logic, comprehensive formatting and layout, and high-fidelity output for the web or print.

Design Once, Deploy Anywhere
A critical aspect of structured content creation is the ability to design a single piece of content that can satisfy the needs of diverse users. This involves connecting to a broad variety of enterprise data sources (often uniting multiple sources into a single report) to provide a summarized view of information. It also demands flexible tools for building business logic, comprehensive formatting controls and the ability to personalize content for specific users. Crystal Reports provides extremely broad data connectivity and an extensible formula language for building complex reports requiring complex business logic. Built-in interactivity, personalization, parameters, drill-down and indexing technologies enable custom content to be delivered to any user, based on security or on user-defined criteria. Finally, any report design can be outputted to a variety of formats, including PDF, Excel, Word and our standard, published XML schema (XML can also be tailored for to match other standard schema).

World Standard
The value of a standard tool extends beyond the widespread availability and general quality of the product. It includes all the value-add often associated with industry standards: large pools of skilled resources, large knowledge base, partnerships and integration with other enterprise software vendors, easy access to consulting and training, third-party books and documentation, the list goes on. Standard tools tend to travel with a whole caravan of support and services that help organizations succeed. As the report design tool of choice in over 300 partners' enterprise software products, including Microsoft Visual Studio.NET, SAP BW 3.0, Peoplesoft, and Hyperion, there's a good chance your organization already has a significant user base and knowledge base on our products.

Ease-Of-Use, Rapid Design
Time-to-market and ongoing maintenance efforts are key areas where IT organizations can look to reduce costs, improve efficiency and better meet business objectives. Report design tools should fit into these goals by providing a broad range of built-in features and functionality and an emphasis on ease-ofuse and rapid prototyping and report production.

Crystal Reports delivers on IT organizations need to reduce time-to-market and minimize maintenance costs. Through eight versions and extensive hands-on work with customers, Crystal Reports has emerged as the most refined and efficient report design tool. It offers code-free design in a graphical environment with powerful experts and over 240 functions - including complex ones like Inventory Turnover and Cash Flow vs. Current Debt - available through an extensible formula language.

Crystal Reports best in class features for ease-of-use also extend report design capabilities to a broader base of users in your organizations. Instead of concentrating report design in an overworked, centralized group, you can spread designers across different business units and get them closer to the actual report consumers.

Designed for the Web
Building one report and distributing it to many different users and devices requires high-fidelity output in a variety of web, print and data exchange formats.

Crystal Reports is designed to produce accurate, high resolution output to both DHTML and PDF for web viewing and printing. Output to RTF enables integration of structured content into MS Word documents. Built-in XML support and a standard Report XML schema deliver output for other devices and business processes and native Excel output enables further desktop analysis of report results.

Alerting is the final component of content personalization. It involves setting thresholds or conditions in a report and then notifying the user if these are triggered during the most recent run of the report. Instead of demanding that users review a report just to see if there is anything critical they should be aware of, alerting provides instant notification.

Crystal Reports includes alerting as a built-in feature of the formula language, allowing the construction of alerts based on any field, calculation or value. Alerts are displayed within the designer, but can also be captured and displayed within Crystal Enterprise or automatically e-mailed out to end users.

Crystal Enterprise

Crystal Enterprise Business Views helps you better manage reporting across multiple data sources and applications by simplifying data access, change management, and data-level security processes. An optional service in Crystal Enterprise, Business Views allow you to integrate data from disparate sources, handle promotion/demotion between development and production environments, and control security at both the row and column level.

Simplified Data Access
Data access is one of the most fundamental, yet difficult aspects of designing a report. Locating the right data, joining tables appropriately, and filtering the data to focus on a specific subject area requires an in-depth knowledge of the underlying data structures.

The Business View Manager allows you to simplify data access for your report designers by insulating them from the raw data structures. You can build connections to multiple data sources, join tables, alias field names, create calculated fields, and then surface this simplified structure as a Business View in Crystal Enterprise. Your report designers can then connect to Crystal Enterprise and use the Business View as the basis for their report, rather than accessing the data directly and building their own queries.

Business Views helps administrators pull data together from disparate sources. Data Connections (created visually or with complex SQL statements) can be integrated into a Data Foundation. Once the Data Foundation is built, Business Elements (a collection of related fields from the Data Foundation) can be created and combined into a Business View.

The modular architecture of Business Views also allows you to readily re-use various components of one Business View to build other Business Views. A single, broad data foundation can serve as the basis for multiple, specialized Business Views. Used carefully, these capabilities allow you to minimize the number of changes required to introduce new data, fields, or formulas into your system.

Granular Data-level Security
Many reporting scenarios involve complex security requirements. Each user is entitled to see a slightly different slice of corporate data, based on their business unit or level of seniority (e.g., telephone billing statement or regional sales pipeline report).

Rather than creating a number of different reports to meet this need, you can create a single report and use the security features of Business Views to filter data appropriately for each user. Using the Business View Manager, you can set up row- or column-level filters and map these filters to users or user groups stored in your existing LDAP, Active Directory, or Windows authentication provider. This security is then consistently applied at the data level, ensuring that any report design based on a Business View will respect the underlying data security.

You can then choose to schedule the report to run regularly. Or you can allow users to refresh it on demand. Regardless, Crystal Enterprise can generate a master instance of the report (with all the data included if you run the report under an administrator context) and then filter the report every time a user views it. All exporting, printing, and report modification requests will also return only the data the user is entitled to see.

Change Management and Re-use
Maintaining a large set of reports is often more time-consuming and complex than new development. Activities such as making small changes in response to user needs, updating business calculations, changing formatting, and moving your reports between development and production data sources all delay you from addressing new requirements.

Business Views includes two key features to help you spend less time on report maintenance. First, you can use Dynamic Data Connections to store connections to multiple instances of the same database (e.g., development, test, and production). By passing a parameter when you're designing (or scheduling) the report, you can select which data source the report runs against. Second, you can store commonly-used functions, text objects, and logos directly in your data foundation. This allows you to easily roll changes across multiple reports by changing the object once.

Crystal Analysis
Crystal Analysis gives analysts a powerful tool for exploring multi-dimensional data and building interactive reports for end users. It provides: connectivity to a variety of multidimensional data sources, extensive analytic functionality, data-based formatting and highlighting and flexible controls for linking together multiple views into interactive briefing books.

Structured Multi-Dimensional Reporting
Many multi-dimensional analysis tools try to accommodate business users by removing some of the more powerful analytic functionality from the tool. The result is that these tools don't have the sophisticated and power that skilled analysts (the primary users of multi-dimensional tools) require.

Crystal Analysis makes a very clear separation between the tasks of the report designer (an analyst who needs extensive functionality to conduct complex analyses) and the report consumer (a business user who wants to walk through an analysis and use the information to drive business decisions). Designers can build sophisticated reports, "lock down" the views and controls and publish the report to the web, where business users can view it.

Crystal Analysis enables designers to build applications that guide users through the process of navigating and exploring OLAP data. By linking multiple views together, designers can walk users through different slices of a data set, reorienting views, displaying trending information and variances and providing charts for enhanced data visualization. End users can easily step through these applications by highlighting data and clicking on transition buttons.

Sophisticated Analytic and Formatting Features
By separating designer tasks from consumer tasks, an analytic report design tool should offer a broad range of powerful analytic functions. This should include extensive calculation capabilities, granular highlighting controls, charting utilities and configurable controls to transition users through different views of the data.

Crystal Analysis offers a completely visual, drag and drop design environment that allows designers to rapidly assemble rich reports. Powerful calculation capabilities and charting functions are built into the tool, as are extensive highlighting options. Crystal Analysis also incorporates Analysis Buttons configurable controls that allow designers to link related views of multidimensional data to create briefing books. These controls preserve the user's context as they move from view to view (e.g. the specific product the user has chosen to analyze travels with them as they move to a different view of the data.

Designed for the Web
A central part of the challenge of exposing multi-dimensional analysis to broad user bases is the difficulty of installing and learning the tools and the complexities of locating and connecting to the appropriate data source. The web offers an ideal opportunity to streamline the access to and deliver of information from multi-dimensional data sources.

Crystal Analysis addresses this challenge through rich featured DHTML components presented within a standard web browser. A broad range of analytic features and dynamic up-to-the-minute access to data are available via the web, ensuring that users can perform a broad range of analytics on the freshest data available.

Articles on Crystal Reports