Defining Cells
Use
Cells enable you to use values that the report displays for particular row/column combinations as operands in formulas. A cell pinpoints a particular location or range within the column-row matrix of a report. In the Report Painter, you can work with rows, columns, and individual cells. If you want to work with cells, you must select the relevant cells.
Procedure
You edit cells in the same way you edit row and column elements.
- Position the cursor on the cell and choose Edit
®
Elements
®
Change/display, or simply double-click the cell.
The cell is selected. All cells you select in this way can then be used in the formula builder in the entire report (all sections and horizontal pages) as operands for the definition of formulas.
- If you don‘t enter a text for the selected cell, the system automatically assigns a description to it. This description is the lead column/column header.
To enter your own cell text, position the cursor on the cell and choose Edit
®
Element
®
Change text. You can then enter a short, medium, and long text for the cell.
- If you use cells as operands in formulas, but do not want to display or print these cells in your report, you can hide the rows and columns used to create the cell by choosing Edit
®
Rows/Columns
®
Hide. If you have selected the affected cells, you can still use them in the formula builder.
- If you want to select cells in exploded rows of a group (set), the selected cell always refers to the highest summation level in the group. If you want to select cells for a subgroup, you must define an additional report row for the subgroup, select the cell you want to use, and then hide the report row.