List Display with Crystal Reports

Use

By integrating SAP BusinessObjects Crystal Reports into SAP List Viewer for SAP GUI (ALV Grid), Web Dynpro ABAP ALV, and POWER Lists you get extensive possibilities for creating formatted reports. The essential functions are printing and formatting of reports.

You can use generic report layouts for all lists or create a report layout of your own for specific lists. You have the following options:

Report Type

Function

Layout

Prerequisites

Generic report (SAP)

The generic report layout can be used in all ALV instances; it is not just for a specific ALV use case.

The generic report layout does not refer to specific data, that is, it does not make any assumptions about the data to be displayed.

SAP delivers a generic report layout.

This function uses the Crystal Reports Viewer.

Generic report (SAP)

The generic report layout can be used in all ALV use cases.

You can specify the generic report layout yourself. (see Creating Generic Report Layouts)

This function uses the Crystal Reports Viewer and also requires that you use the Crystal Report Designer.

Special report

The special report layout refers to a specific ALV use case and to specific data to be displayed.

You assign the special report layout to a special ALV use use and save the ALV layout.

You create this report layout in Crystal Report Designer.

This function uses the Crystal Reports Viewer and also requires that you use the Crystal Report Designer.

Prerequisites

See Prerequisites: List Display with Crystal Reports

Features

You can display or print lists with a generic report. If you need another layout then you can export, edit, and reimport another as a special layout.

Displaying Lists

You can switch between SAP List Viewer and Crystal Reports Layout for displaying lists.

Be aware of the following system behavior:

  • If you are already displaying grouped lsits with a Crystal Repots layout then the grouping is displayed in the left area of the screen as a structure.

  • Sums are displayed below the grouped data despite previously being displayed at the top in ALV.

  • In the Crystal Reports layout you cannot navigate to detailed data, that is, to individual documents.

  • Texts that you create in the Crystal Reports Designer are not taken into consideration in the translation environment.

Showing and Hiding Parameters

To show or hide parameters, choose the Show/Hide Parameter Area pushbutton.

Showing and Hiding Structures

To show or hide structures, choose the Show/Hide Group Structure pushbutton.

Exporting

Proceed as follows to export:

  1. Select the Export Report pushbutton and save the report layout locally as an RPT file.

    When exporting report layouts, additional information (for example about groups, sums, or sorting) is also transported.

  2. Open the file with the Crystal Reports Designer and make the required changes.

Importing

Proceed as follows to import:

  1. To import a report layout, choose the Import Report pushbutton.

    After the import, the report layout is displayed as a specific layout in the layout settings.

  2. In SAP List Viewer for SAP GUI choose Start of the navigation pathSettings Next navigation step Layout Next navigation step SaveEnd of the navigation path to save a special report layout as a user-specific layout or as a presetting for this one ALV use case.

    In Web Dynpro ABAP ALV choose Start of the navigation pathSettings Next navigation step SaveEnd of the navigation path to save a specific report layout as user-specific or as a set view.

Printing

To print a report, choose the Print Report pushbutton.

More Information

For more information, see the SAP Help Portal at http://help.sap.com/Information published on SAP site under SAP Crystal Reports.