Defining the Columns of the Form 

Use

Define three columns: actual data, plan data and percentage to which the plan was fulfilled, Plan fulfil. %.

In the first column, the actual data will be defined.

Procedure

  1. Double-click Column 1.
  2. In the dialog box, select Characteristics.
  3. Choose .
  4. Enter the following data:
    5.

    Field

    Data

    Plan/act. ind.

    select

    Record type

    select

    Period

    select

  5. Choose .
  6. In the Plan/act. ind. line, enter the following data:
    7.

    Field

    Data

    From

    0

  7. In the Record type line, enter the following data:
    8.

    Field

    Data

    From

    F

    Here you define that actual figures will be shown, as well as the record type billing data.

  8. Position your cursor on the Period field.

    9. You can enter either fixed values or variables for the characteristic values. Variables let you use the same form and report to analyze different characteristic values.

  9. Choose .
  10. In the dialog box, select FROMPER ( From period ), then choose .
  11. Position your cursor on the Period to field.
  12. Choose .
  13. Select TOPER (To Period), then choose .
  14. Choose .

    15. The system displays the Enter Texts dialog box. Here you can enter various column headers.

  15. Enter the following data:
    16.

    Field

    Data

    Short

    Actual

    Medium

    Actual

    Long

    Actual; $Pfr - $Pto

    By entering $Pfr and $Pto in the text, you are defining local text variables. These variables make it possible to display the selected periods in the column header of the report. To do this, you now have to maintain these variables. The semicolon separates the two lines of the column header, so that Actual will appear in the first line and the periods in the second line.

  16. Choose .
  17. Choose Confirm.
  18. Select Column 2, then choose .
  19. In the dialog box, enter the following data:
    20.

    Field

    Data

    Characteristics

    select

  20. Choose .
  21. In the Available Characteristics Area, select Version.
  22. Choose .
  23. In the Plan/act. ind. line, enter the following data:
    24.

    Field

    Data

    From

    1

  24. In the Record type line, enter the following data:
    25.

    Field

    Data

    From

    F

  25. In the Version row, enter the following data:
    26.

    Field

    Data

    Version

    110

  26. Position your cursor on the Period field.
  27. Choose .
  28. In the dialog box, select FROMPER ( From period ), then choose .
  29. Position your cursor on the Period to field.
  30. Choose .
  31. Select TOPER (To Period), then choose .
  32. Choose .
  33. Enter the following data:
    34.

    Field

    Data

    Short

    Plan

    Medium

    Plan

    Long

    Plan; $Pfr - $Pto

  34. Choose , then choose Confirm.
  35. Select Column 3, then choose .
  36. In the dialog box, enter the following data:
    37.

    Field

    Data

    Formula

    select

  37. Choose .

    38. The Enter Formula dialog box appears. Now you want to calculate the actual data as a percentage of the plan data.

  38. Enter the following data:
    39.

    Field

    Data

    Text field

    X001 %A X002

  39. Choose .
  40. In the dialog box, enter the following data:
    41.

    Field

    Data

    Short

    Plan comp.

    Medium

    Plan completion

    Long

    Plan completion

  41. Choose .
  42. To display two-line column headers, choose Formatting ® All Columns ® Text Length..
  43. Enter the following data:
    44.

    Field

    Data

    Two-line long text

    select

  44. Choose .
  45. Remain on the Report Painter: Create Form screen.