1. On any Create Report screen, choose Goto ® Row overview.

The Create Report: Row Overview screen appears.

2. Enter the name of the set(s) to be used as the report row block.

You can use a basic, data, single-dimension, or multi-dimension set.

You cannot enter a set that contains characteristics that are already being used in a column block or as selection criteria in the report. You can use the same characteristic in more than one row block and you can use more than one characteristic in a row block(s); however, you cannot use the characteristic again in a column block or as selection criteria in the report.

You can enter a set that has not yet been created in your system. The system asks you whether you want to create the set and displays a series of dialog boxes in which you choose whether you want to create a report set or a general set and then select the relevant set type.

You can enter basic and multi-dimension sets that have been created for characteristics from tables other than the table that the report uses. To do so, the characteristic of the row block set must be compatible with the corresponding characteristic in the report’s table.



You create a report for a library that uses table GLT1 and want to enter a hierarchy of accounts in the report rows. You could enter a Controlling cost element group created for the characteristic "Cost element" (KSTAR) in table CCSS as the row block. In this case, characteristic "Cost element" is compatible with the characteristic "Account" in table GLT1.



The table-independent usage of sets in reports is not possible for data and multi-dimension sets.

3. For each row block, enter the following data as required:

– Specify whether you want to insert a page break before a row block or insert blank lines between row blocks.

To insert a page break before a row block, enter * in the Page break field.

To insert a specific number of blank row lines before a row block, enter the number of blank row lines you want in the Page break field.

– Specify whether or not the system should insert column headings before a specific row block (set text for the row block). Select Print heading if you want the system to insert a column heading for the corresponding row block.

– Specify if you want to hide the row block. The row block is then hidden for all column blocks. You can refer to a hidden row block in a formula and/or key figure; however, the row block is not displayed in the report.

– Specify whether you want to inactivate the row block so that it is ignored in the report.



When you set a row block as inactive, the Report Writer completely ignores the row block. You cannot refer to an inactive row block in a key figure or a row formula. This function can be used for test purposes.

– Specify whether you want to switch the +/ sign for all report rows in the row block. If you set this checkbox, the +/ sign will always be switched for the values in the respective report rows.

The Change +/ indicator assigned to a row block overrides the format group settings specified for the Change +/ sign indicator in the standard layout parameters (Create Report: Report layout: Representation screen).

– Enter the lower summation level (From level) for displaying totals for the row block. You can enter a number greater or less than 0.

– Enter the upper summation level (To level) for displaying totals for the row block. You can enter a number greater or less than 0.



Summation levels assigned to a row block override the summation levels assigned to the entire report in the standard layout parameters (Create Report: Report Layout: Row Totals screen). You can change these summation levels after you have output a report to your screen. For more information see sorting report rows and functions in the report output.

4. Choose Enter.

The descriptions for the row blocks appear. The Set, Formula, and Key fig. block fields are set accordingly, depending on if you entered a set, formula, or key figure in the Row block field(s).



The Report Writer can use sets from all set classes. However, a set name is only unique within one set class. If you entered a set name that exists in two different set classes, the system displays a dialog box in which you select the set that you want to use as the row block.

5. If you want to enter additional text for the row blocks:

a) Position the cursor on the row block for which you want to enter the texts and choose Extras ® Additional texts.

The Texts for Row Block No. <Number> dialog box appears.

b) Make the following entries:

Lead column fields:

Select the Text indicator if you want to enter your own text for the lead column. Enter the text in the field next to the Text indicator.

Select the Text from set indicator if you want to use the description entered in the row set as the lead column text. This option is the default setting.

Sum total fields:

Select the Text indicator if you want to enter your own text for the highest row block total. Enter the text in the field next to the Text indicator.

Select the Text from set indicator if you want to use the description entered in the row set as the text for the row sum total. This option is the default setting.

6. On this screen, you can use the additional processing functions in the table for the Create Report: Initial Screen as described in creating a Report Painter report as well as the functions in the following table.

Inactivating Columns for a Row Block

Entering Characteristic Information for a Row Block

Inserting Formulas in Row Blocks

Inserting Key Figures in Row Blocks