Sets in the Report Writer

Use

The Report Writer uses sets to structure and select report data. Report structure and contents are defined according to the sets that are used for rows, columns, and selection criteria. These sets include basic, key figure, single-dimension, and multi-dimension sets.

You can use sets as:

  • A row block

The row block contains the characteristics that you want to include in the rows of your report (for example, cost center and account numbers).

  • A column block

The column block contains the characteristics that you want to include in the columns of your report (for example, periods, currencies, and amounts).

  • General selection criteria

The selection criteria contain the characteristics that you want to use to select the report data (for example, year, period, company, and ledger).

Before you can begin creating a report, you must first create the sets that the report will use. If the sets you need already exist in your system, you do not need to create new sets for a report. Also, since sets are not report-specific, you can use the same sets for more than one report.

Note Note

You can only use a characteristic once in a report - in a row block, column block, or as selection criteria. For example, if a characteristic in a set is already used in a row block, you cannot use the characteristic in a column block.

But you can use the same characteristic in multiple row blocks or multiple column blocks. You can not use the same characteristic in a row block and a column block.

If you use the characteristic "account" in row block 1, you can also use the same characteristic in row block 2. However, you can not use the characteristic "account" in a row block and a column block.

End of the note.

This section contains:

Defining Report Data

Using Sets in Report Rows

Using Sets in Report Columns

Suppressing Rows and Columns

Using Sets as Selection Criteria

Entering Set Text for Reports

Using Variables in Report Writer

Using Set Formulas in Report Writer

Using Symbolic Names in Report Writer

Setting Format Groups in Sets

For more information on creating sets, see creating sets .