Editing a Report

It is now possible to edit your report data using the Report Writer. You can also change the layout of the report. The most important functions of the layout design are summarized below.

Summation levels

In the report screen, you can use the menu sequence  View Summation level to specify the number of summation used to calculate total values. All totals that do not lie within the specified interval will be hidden. A summation level corresponds to a hierarchical level (for example, material level). Summation level 1 is the lowest hierarchical level. Summation level 2 is the next level up, and so on. The individual values are on the summation level 0.

The summation levels can be specified both universally (for the entire report) or locally (for specific blocks of rows). In this case, the local settings overwrite global values.

Report views

If a report is displayed on the screen, the Report Writer will then set page breaks so that exactly one page fits into the current window. This view will be defined as the standard view. As the Report Writer always processes exactly one page, you can only use the page keys and page icons to page up and down; the scroll bars cannot be used.

The page view can be determined via  Settings Page view . The page breaks in the page view correspond to those defined in the report layout.

Hide and show rows

The function  Edit Hide rows exclude certain preselected areas of your report from the display. You can undo this command with Edit Show rows.

Expanding and collapsing report rows

 View Hierarchy Collapse allows you to hide the report rows of the sub-trees that are located underneath. View Hierarchy Expand allows you to undo this command level by level.

If you want to display all the report rows that were hidden by collapsing the hierarchy or restricting the summation levels, select,  View Hierarchy Expand all. View Collapse all allows you to reduced every row block to the highest summation level.

Texts and Annotations

You can create an annotation for your report.

Select:  Extras Annotation.

You branch into the text editor of the Report Writer.

Via the menu sequence  Settings Texts, you can create and format a title page, the last page, as well as headers and footers using word processing functions.

For example, you can store variables in the header for the author of the report, the date of the selection or the name of the person who last changed the report.

Layout parameters

Using the menu sequence  Settings Layout you can specify the page format, display form, rows and columns of the report according to your needs and you can determine the settings for the graphics function. You can make these layout settings with Report Save settings.

The following table gives you an overview of the most important parameters that you can determine in the menu  Settings Layout .

To set the column width of the key column and the other columns, select  Settings Column width.

Setting the threshold value condition

You can set a threshold value condition in a report in order to hide or highlight lines depending upon the number values in a reference column.

In order to save a threshold value requirement, select  Edit Threshold value. A dialog box appears. Specify the following parameters:

To ignore the +/- sign during a check, select the indicator Ignore +/- sign. This is useful, for example, if you want all of the lines in a report to be highlighted, for which a deviation, either positive or negative, exceeds a certain threshold value.

Sorting

The report can be sorted. Sorting retains the sequence which is specified by the summation hierarchy. Only those report lines are sorted that are in succession and have the same summation level. If the report was set so that only the lines of a summation level are displayed, then these lines will be continuously sorted. Only those lines from the current section of the report are sorted. The reference column according to which sorting is done, will then be marked with a symbol in the column heading.

To start the sort function, position the cursor on the column to be sorted and select  Edit Sort in ascending order or  Edit Sort in descending order . In order to restore the original sequence of the report lines, select  Report Remove sort sequence.

Saving selected date

You can save the selected data from the report. To do this, select  Report Save data.

Sending reports

With the  Report Send command, you can send a report within the R/3 system via SAPoffice. The only condition is that the Save data permanently indicator was selected, which is in the selection screen for executing the evaluation (see Executing an Evaluation With a Selection ).

Output of reports

You can output a report in several ways:

Select  Report Print.

A dialog box appears where you can specify whether the current page or the entire report is to be printed. If you want to print the complete report, the number of lines per page will be taken from the report layout. To show additional options for the printing function, use the More options key. (page selection, number of lines per page, page length).

This report allows you to file your report under a specified name and to control the medium (application server or presentation server) used to output the report.

 To do this, select: Report Export .

A window appears in which you can assign a file name and define the output parameters.

You can issue certain preselected areas of your report as graphics.

To do this, proceed as follows:

The first screen to appear is the graphics type that you determined with  Settings Layout Page/control .

Selection Log

By selecting the menu sequence  Extras Selection log you can display a selection log for the report. In the selection log you will find technical information on the report (for example, selection criteria, statistical data for the table, statistics for record processing, runtime, etc.).