Defining Rows and Columns
Creating a Report
The Report Painter: Create Report screen appears.
You can also define a Report Painter report from any Report Writer reporting screen by choosing Report Writer ® Report Painter ® Create report.
Both reports must use the same library.
The next screen displays an empty report containing four rows and four columns, that is, the basic structure for a report. You define your report on this screen.
A dialog box appears in which you can enter a short, medium and long text for the report description.
You can also enter text for the report section. A section is an independent block (with both rows and columns) within one report definition. You can define more than one section in a report.
Defining an Element
Every object on the screen that you can click on is known as an element. Each row, column, and cell is an element of the report.
Position the cursor on the element you want to define and choose Edit® Element ® Define element, or double-click the element. A series of dialog boxes is displayed in which you define the element.
You are creating a Report Painter report and want to define the first column:
In this example, we are using a key figure with characteristics.
The following dialog box lists all key figures selected for the library that your report uses.
The following dialog box lists all characteristics that can be entered in the column. These are the characteristics selected for the library that your report uses. The order in which the characteristics appear in the selection list is determined by the Position field in the library definition. This allows you to place the characteristics that you use regularly in your reports at the beginning of the selection lists.
You can enter individual values, intervals of values, or groups for the chosen characteristic(s).
If you want to define all possible values for the chosen characteristic(s), enter an asterisk (*).
If you want to define an initial value for the chosen characteristic(s), enter the character #.
When you enter values for the chosen characteristic(s), you can use the Refresh function to display the texts defined for the values and/or variables you entered.
a) Position the cursor on the relevant entry field and choose Variable on/off.
An icon appears before the field, and the field size is adjusted accordingly.
b) Enter the name of the variable and choose Confirm.
You can only enter variables that already exist in your system.
For more information about variables, seeVariables: Introduction .
If you want to later change the text you entered for the report column, you can simply overtype the column text or position the cursor on the column element and choose Edit® Element ® Change text.
Beginning with Release 3.0C, you can use variables in your column headings. The variables are replaced with the default variable value when you execute your report if the column text type Key is selected in the reportís standard layout (Column Texts screen).
You enter the variable in the dialog box for the three texts describing the report column. To enter a variable as a column heading, enter& and the name of the variable.
For example, your report uses the value variable &PERIOD for the characteristic period and you want to display the current value for the period in a column heading. You enter the variable&PERIOD in the column heading of your report. If the column text type Key is selected in your reportís standard layout, the variable &PERIOD is replaced with the period value (for example, 5 ) when you execute the report. The period description is printed for all other column text types (for example, May).
Using the Formatting® All columns ® Text length function, you can determine which of the texts you want to use as the column heading.
The dialog box in step two prompts you to define the column as a key figure with characteristics, a predefined column, or formula.
When you define other elements in your report rows or columns, you can do so using the Select and Copy functions. Select the element that you want to copy, position the cursor on the row or column where you want to insert the copied entry, and choose Edit® Selected area ® Copy. You can then change the copied element as desired.
a) Select Formula
The system displays a formula editor, in which you can define a formula to calculate a column using other report columns and previously defined cells.
b) Enter the formula and choose Confirm.
You can define formulas that refer to elements in different column blocks. However, you can only define formulas within one report section.
The above example procedure describes how to define report columns. You define the report rows in the same way, but you cannot enter predefined columns in report rows. You define row elements using the characteristics selected for the library that the report uses. You can also use row models to define your report rows.
The following graphic is an example of the row and column definitions in a report.
The options under Edit® Rows allow you to select a variety of special functions for editing report rows. The Get row model option inserts a predefined row structure in your report rows. For more information, see Defining Row and Column Models. Insert blank line inserts a blank line in the current row (where the cursor is positioned).
The Edit® Rows ® Hide function hides the report row on which the cursor is positioned. The hidden row retains its content and can still be used in formulas. You can edit hidden rows by choosing Hidden rows ® Change. You can also delete and display the hidden rows (Delete and Show functions).
The Edit® Rows ® Explode function expands the hierarchical levels of the group/value interval defined for the row characteristic. For more information, see Exploding Report Rows .
The options under Edit® Columns allow you to select a variety of special functions for editing report columns. The Get column model option inserts a predefined column structure in your report columns. For more information, see Defining Row and Column Models.
The Edit® Columns ® Hide function hides the report column on which the cursor is positioned. You can process hidden columns in the same manner as the hidden rows.
Using Formula Variables in Report Columns
A formula variable represents a user-defined formula, which determines a value for the variable. Using formula variables in report columns, you can create several new types of reports.
For more information, seeUsing Formula Variables in Reports: Examples .