Create Cells

This procedure is used to create cells in a report. You can create both calculation cells and text cells. For more information, see the Report Definition process.

Note that it is best to create cells when a report is fully defined and has a final layout.

Before You Start

A report with columns and lines must be created in ‘Report. Open’ (RGS600).

Follow These Steps

  1. Start ‘Report. Open’ (RGS600/B).

  2. Select option 13 = Cells for the report, to start ‘Cell. Open’ (RGS630/B).

  3. In (RGS630/B), create a new cell by specifying a column and line number and select New.

  4. Select one of the following alternatives:

    • To create a text cell, go to step 5.
    • To create a calculation cell, go to step 7.

    Create a Text Cell

  5. On the E panel, specify cell type 1 = ‘Text cell’ and type the text in the ‘Cell text’ field. Press Enter. (See example below.)

  6. Return to step 4 to create more cells, or press F3.

    Create a Calculation Cell

  7. On the E panel, specify cell type 0 = ‘Calculation cell’.

  8. Specify how to edit the field by specifying number of decimals, whether reverse sign is to be used, how cell values are to be adjusted, where to place minus sign and how to present zero values. Press Enter.

  9. In ‘Cell. Specify Calculation’ (RGS632/B), define the calculation. You do this by specifying the operator, column number, line number and factor for each cell included in the calculation. (See examples below for how to define different calculations.)

  10. Press Enter. Return to step 4 to create additional cells, or press F3.

Example - Text Cell

Line 60 in the example below is a calculation line for determining the contribution margin ratio. This calculation is irrelevant under column 02 since this is a percent column. By using a text cell, a blank space is printed instead.

Col. 00 Col. 01 Result Col. 02 Percent
10 Total revenues 7,010 100.00
20 Total cost of goods 5,750 82.03
30
40 Contribution margin 1,260 17.97
50
60 Contribution margin ratio in % 18 ________

Example - Calculation Cell

In the example below, the number of decimal places in column 01 is zero according to the column definition. By using calculation cells, the number of decimal places on line 60 is changed to two.

Col. 00 Col. 01 Result
10 Total revenues 7,010
20 Total cost of goods - 5,750
30
40 Contribution margin 1,260
50
60 Contribution margin ratio in % 18.00
Related topics