User`s guide

Tip:
For additional information about parameters and general report design topics, see the Crystal Reports
Online Help .
24.1.3.2 Reporting off other SAP data sources
In addition to the previously mentioned drivers, Crystal Reports provides the Open SQL driver, which
allows you to report off additional SAP data sources from within Crystal Reports.
24.1.3.2.1 Reporting off tables, views, clusters, and functions
The Open SQL driver is the most powerful of the drivers due to the flexibility it provides for accessing
data in SAP. This flexibility, however, results in a higher level of complexity than with the InfoSet driver.
When you create reports that use the Open SQL driver, you gain easy access to SAP's transparent
tables, pool tables, cluster tables, and views. Users who are currently involved with the production of
ABAP reports will find it easy to build reports quickly with this driver.
Advanced functionality in the driver also allows reporting against ABAP functions and ABAP data
clusters. ABAP developers can use these features to perform advanced tasks such as reporting against
data clusters in HR.
Open SQL driver overview
The Open SQL driver is the most powerful of the SAP BusinessObjects Enterprise XI Integration for
SAP Solutions drivers because of the flexibility that it provides for accessing data in SAP. By writing
reports with the Open SQL driver, you gain easy access to SAP's transparent tables, pool tables, cluster
tables, and views. If you are currently involved with the production of ABAP reports, you will find it easy
to quickly build reports with this driver.
The advanced functionality of the driver allows you to report against ABAP functions and ABAP data
clusters. ABAP developers can therefore perform advanced tasks such as reporting against data clusters
in HR. The Cluster Definition tool is provided as part of the server installation for users who need to
add, edit, and delete data cluster definitions. Developers can also utilize ABAP to augment report
processing.
Additionally, the Open SQL driver provides the ability to secure the data to which users have access.
You can place limitations either on individual tables, or, at a more granular level, on the individual rows
within a table. For more information about using the Security Definition Editor to customize your own
set of data access authorizations, see the “Defining Security for the Data Access Kit” section in the
SAP BusinessObjects Business Intelligence Platform Installation Guide .
2012-03-14596
Integrating Business Applications with Crystal Reports