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:
The row block contains the characteristics that you want to include in the rows of your report (for example, cost center and account numbers).
The column block contains the characteristics that you want to include in the columns of your report (for example, periods, currencies, and amounts).
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.
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.
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 For more information on creating sets, see creating sets.