Defining Sections 

Use

A section consists of one or more physical rows and columns forming a logical unit. In the vertical direction, a report consists of one or more sections. Each section is displayed on a new screen. You can define sections with key figures and characteristics, as well as sections with derived basic key figures.

In a section that contains calculated key figures, you can create an overview of the most important values used in your report. A section with calculated key figures is a new report section and is displayed on a new screen. You normally define a section with basic key figures at the end of your report.

Sections with Calculated Key Figures

  1. To define a section with calculated key figures, first select the cells you want to use in the section. For information on selecting cells, see Defining Cells. You can also enter your own text for these cells.
  2. Choose Edit ® Sections ® New section. In the New Report Section dialog box, select Section with calculated key figures.
  1. Position the cursor on the row or column and choose Edit ® Elements ® Define element or double-click on the row or column.

    2. The section with calculated key figures is made up of a row/column structure in which you enter short, medium, and long texts.

  2. Define the cells you want to use in the section at the point of intersection of the row/column combination. Position the cursor on the appropriate cell and choose Edit ® Elements ® Define element, or double-click on the cell.

You enter cell calculations for the section with key figures in the Formula Builder. All selected cells of the report are displayed in the Formula Builder as buttons. You can then define your key figure formula as required.

The Formula Builder enables you to use the selected cells in the section with calculated key figures. You can also use cells that were calculated using the selected cells.

Another feature is that you can reselect cells used in the section with calculated key figures to calculate values for other cells within the section (recursive cell definition).

If you don’t want to display or print the cells you use in your section with calculated key figures in the other sections of your report, you can hide the corresponding rows and columns by choosing Edit ® Rows/Columns ® Hide.

 

Sections with Characteristics and Key Figures

  1. To define a new section in your report, choose Edit ® Sections ® New section.
  2. In the following dialog box, select Section with characteristics and key fig.

A new row and column structure appears for you to define your new report section. You define rows and columns as described under Defining Columns and Defining Rows.

  1. You can switch between the different sections by choosing Goto ® Section ® and then First section, Previous section, Next section, or Last section.

You can only perform calculations using columns within the same section. For calculations between sections that use columns, you must select cells. For more information, see Defining Cells.

Once you have defined a report, you can display and print out a table of contents of the report with Formatting ® Section overview.

The overview contains the characteristics and characteristic values used in the individual sections, horizontal pages, and general data selection criteria. It also provides general information such as the user who last changed the report and the report name, as well as details on the report formats.

If you double-click an individual characteristic, you can see where this characteristic is used in the report definition.