Creation of Crystal Reports

Creating a new report with a template

You can create a new Crystal Report based on a query.

In Crystal Reports Designer, choose  SAP  Create New Report from a Query .

Editing a report

You can create a new Crystal Report based on an existing report that you have already copied:

1. Opening an existing report

   In Crystal Reports Designer, choose  SAP  Open Report .

2. Logging on to the BW system

   The SAP Logon dialog box appears and you have to select the corresponding SAP BW system. Log on in the usual manner.

3. Selecting a report

   1. A dialog box appears. Choose Search and select Search in Technical Name.

   2. Enter 0CR*, for example, to search for an existing report.

   3. Double-click the required report to display it.

4. Editing a report

   You can edit the report and use drag and drop to transfer key figures and features, for example, from the Field Explorer to the Design area.

   Note

   In the Field Explorer, in the context menu of the parameter field, choose New to add a new field.

5. Saving a report

   Crystal Reports are stored in the BW system as BI content and can be saved in an existing BW role (PFCG role) or in one of your own roles.

   You have the following options:

   • Choose  SAP  Save As .

     The system creates a new report in an active version.

   • Choose  SAP  Save Report .

     The system overwrites the active version.

Listing reports

You can use the report RSCXP_CRYSTAL_SHOW to display reports and associated roles in the BW system.

Publishing a report

You can publish Crystal Reports directly when you save them in Crystal Reports Designer or you can publish them in the BW system in Content Administration Workbench (transaction /Crystal/RPTADMIN).

Proceed as follows in Content Administration Workbench:

1. In the left-hand screen area, choose  Enterprise system  Available systems .

2. A dialog box appears in which you can set the system, RFC connection, or language, for example.

3. In the left-hand screen area, choose Publish reports and then Select reports and roles to publish.

4. Select the corresponding system and enter the required selection criteria, for example, SAP_BWC* (as the role) and 0CR* (as the report).

5. Select the desired reports and choose Publish.

   When the report is published on the BOE, the language versions are created.

Deleting a report

In Crystal Reports Designer, choose  SAP  Open Report . In the subsequent dialog box (Open a Crystal Report from BW), click a report and choose Delete in the context menu. The report is then deleted with all references, that is, all of its role assignments are deleted and the report is also deleted on the BOE.

You can also delete reports in Content Administration Workbench (transaction /Crystal/RPTADMIN).