Related topics
This panel displays all columns that have been created for the selected report. You can add, change, copy or delete columns.
Options
| Selection | Use this option to select key values for the key value selections for the column, line or version. Note: This option is allowed for columns with Type <90, Type 1 lines and for all versions. |
Selection fields
- Column no
- Displays the number of the report column.
- Heading 1
- Displays the top heading of the report.
- Heading 2
- Displays the second heading of the report.
- Status
- Displays if there is error in the Select key values (ANLD5521) panel that has been done for the column.
Work with report columns (RWRD11004)
You can access this panel in three different modes. If you selected the Add option from the previous panel, all fields can be maintained. If you selected the Change option, all fields except the Column number key field can be maintained. If you selected the Display option, no fields can be maintained.
On this panel you decide what information each column in the report shall contain, which values, and from which periods these values shall be retrieved.
Note: The calculation in a column is always performed after the calculation on a line.
Function keys
| Valid column types | Display the valid column types. When creating a column, you have to define the type of values the column shall consist of, i.e. a column type. |
- Report
- Displays the name and description of the report to maintain.
- Column number
- This field is used only for new entries. Enter the number for the column you are creating.
- Column heading 1
- Enter the first line heading for this column.
- Column heading 2
- Enter the second line heading for this column.
- Column type
- Enter a code for the type of values the column should consist of. Valid codes for the type of report you are creating are displayed if you click Valid column types.
- Budget number
- Enter the number of the budget from which values shall be retrieved, if the column type concerns budget values, i.e. column type 21, 22, 23, 41, 42 or 43.
- Balance type
- Enter the balance type of the value that you want to retrieve. It must be a valid code from the Balance type table and allowed for the selected keys.
- Edit code
- Enter the edit code for the printout of the column values. If you select reverse sign YES in the report description, you should use an edit code with minus sign for negative values, otherwise the debit amounts will be printed with CR.
1 Values are printed with two decimals. Credit values are represented by –. Example: 1234567890.12- 2 Values are printed as integers. Credit values are represented by –. Example: 1234567890- 3 Values are printed in thousands with one decimal. Credit values are represented by –. Example: 1234567.9- 4 Values are printed in thousands. Credit values are represented by –. Example: 1234568- 5 Values are printed in millions with one decimal. Credit values are represented by –. Example: 1234.6- 6 Values are printed in millions. Credit values are represented by –. Example: 1234- 11 Values are printed with two decimals. Credit values are represented by CR. Example: 1234567890.12CR 12 Values are printed as integers. Credit values are represented by CR. Example: 1234567890CR 13 Values are printed in thousands with one decimal. Credit values are represented by CR. Example: 1234567.9CR 14 Values are printed in thousands. Credit values are represented by CR. Example: 1234568CR 15 Values are printed in millions with one decimal. Credit values are represented by CR. Example: 1234.6CR 16 Values are printed in millions. Credit values are represented by CR. Example: 1234CR 21 Values are printed with two decimals and thousand separators. Credit values are represented by –. Example: 1,234,567,890.12- 22 Values are printed as integers with thousand separators. Credit values are represented by –. Example: 1,234,567,890- 23 Values are printed in thousands with one decimal with thousand separators. Credit values are represented by –. Example: 1,234,567.9- 24 Values are printed in thousands with thousand separators. Credit values are represented by –. Example: 1,234,568- 25 Values are printed in millions with one decimal with thousand separators. Credit values are represented by –. Example: 1,234.6- 26 Values are printed in millions with thousand separators. Credit values are represented by –. Example: 1,234- 31 Values are printed with two decimals and thousand separators. Credit values are represented by CR. Example: 1,234,567,890.12CR 32 Values are printed as integers with thousand separators. Credit values are represented by CR. Example: 1,234,567,890CR 33 Values are printed in thousands with one decimal with thousand separators. Credit values are represented by CR. Example: 1,234,567.9CR 34 Values are printed in thousands with thousand separators. Credit values are represented by CR. Example: 1,234,568CR 35 Values are printed in millions with one decimal with thousand separators. Credit values are represented by CR. Example: 1,234.6CR 36 Values are printed in millions with thousand separators. Credit values are represented by CR. Example: 1,234CR 81 Values are printed as percentage markings, given in the report description. Example: *** Note: If the Column type is 23, 43 and 91 only the edit code 21 is printed with two decimals and thousand separators. The reason for this is that these column types are in percentages. All other edit codes are printed with thousand separators but without decimals.
- Year
- Enter the year range for the column values. Both relative and absolute values can be used.
00 current year XX- number of prior years (trailing minus sign) XX number of future years If you use relative years you have the option of defining the current (or actual year) during the report printout.
- Relative year
- Set this field to YES if the year value is a relative year.
- Period
- Enter the period range for the column values. Both relative and absolute values can be used.
00 present period XX- number of past periods (trailing minus sign) XX number of future periods 98- to last closed period (trailing minus sign) If you use relative periods you have the option of defining the current (or actual one) during the report printout.
- Relative period
- Set this field to YES if the period value is a relative period. If you have entered 00 as period, and define it as absolute, this combination will give you the opening balance in an DC1 Financials report.
- Calculation
- You can enter a formula, if the column should consist of values calculated from other columns or a percentage from the Percentage table. Columns are stated in the format CXX, where XX is the column number. Percentages are stated in the format %XX, where XX is the code for percentage from the Percentage table. You can also use the SLP code when calculating values. SLP, which means SELECTED PERIOD, is the current period number, retrieved when printing the report, to be used when calculating an average for the values in the selected periods. You can also use logical operators (<,>,=,<=,>= ) where the value preceding the operator is checked against the value after the operator, if it is false the value preceding the operator will be zero.
Example: (C10 + C20)/SLP * %15 + 1000
You can add a comment to the formula, if you wish. A comment must be preceded by an exclamation mark (|).
Note: The calculation in a column is always performed after the calculation on a line.
Work with report columns, Copy (RWRD11005)
- Report
- Displays the name of the report from which you are copying columns.
- Column no
- Displays the number of the column you are copying.
- New column no
- Enter the number of the new column.
Work with report columns, Deletion (RWRD11008)
Work with report columns, Valid column types (RWRD11011)
This panel displays the valid column type for the type of report you are creating. Different column types are valid for different types of reports. The column type is defined on the Work with report columns panel, in the Column type field. For column types 23, 43 and 91 only the Edit code 21, which you select on the Work with report columns panel is printed with decimals.