The Columns Tab

Here you enter of which columns the report should consist horizontally. Depending on which column type you select, different database fields can be loaded and calculations can be made among them. By right-clicking you can copy/paste columns. The tab mainly consists of two sections. The top section is called Overview:

The Overview section under the Columns tab

In the Overview, information for each column is entered row by row. Row 1 then corresponds to the information in the first column which will be located to the far left in the report.

Number

A number is displayed here for the column.

Type

Enter which column type you want to use or press F4 to see the available types. There are four column types to choose from:

• Database (text)
• Database (num)
• Calculation
• Text

The chosen column type determines the type of contents in the column. See below.

Contents

Select the information that the column should contain. The selectable contents is determined by which column type that has been entered above. If Database (text) has been selected as column type, then the contents to select from will be account, account name and sub-objects and their names. If Database (num) has been selected as column type, then the contents to select from will be different values loaded from the database such as OB, Period Balance, Accumulated Budget, etc. If you select Calculation as column type, you can enter a formula for calculation between columns or account intervals (for examples of calculations, see further down on this page).

In the Report Generator procedure it is possible to design reports that will show a rolling 12-month result back in time. When constructing reports, Rolling periods are selected together with the number of periods for which data will be displayed. Finally, if you have selected Text as the column type you can enter any text.

The contents can be loaded by pressing F4 to select among available options.

The contents of the column type database (num) is validated.

The Select column contents window.

Heading

Enter a text which you want as the column heading.

Position (cm)

Enter the position of the column in the printout. The position should be entered in centimeters. The position is determined from the left side of the report. At the far bottom of the window there is a preview of how the columns will be positioned on the printout.

Width (cm)

Enter how wide you want the column to be. Enter the value in centimeters.

Adjustment

Select if the column values shall be right or left adjusted.

In the other section called Details, you will find more detailed information concerning the column you have selected in the Overview section.

The Details section under the Columns tab.

Contents

In this field you enter the information that the column in question should contain. The field is in reality the same as the Contents field in the Overview section but this field is wider in order to see and enter e.g. large formulas.

Terms that can be used in calculations:

• Field names such as database fields, e.g. PERSALDO
• K1 means the value in column no. 1
• A1[2] means the value for accumulator 1, column 2
• A1:A3[4] means the total of accumulator 1 to (and including) accumulator 3, column 4
• Constants and the four rules (of arithmetic)

Examples of calculation formulas:

• (K2/K3)*100 gives column 2 as a percentage of column 3.
• (K2/A1:A3[2])*100 gives the value of column 2 as a percentage of the total for accumulators 1-3 in the same column.

Font Style

Here you can select a font style for all text or data included in the selected column. There are three options for each font style:

1. Filled - setting under the Section tab determines which font style that applies for the current column.
2. Check mark - current font style will apply for the column, regardless of what has been entered under the Section tab.
3. Unmarked - current font style will not apply for the column, regardless of what has been entered under the Section tab.

Decimals

Enter the number of decimals that should be shown for the values in the current column. This field is not displayed if the current column type is Text or Database (text).

Background

Here it is possible to enter a background color for the column in question. No background color is selected by default, that is, the background color entered under the Section tab determines which color that will be used.

Text Color

Enter the text color that will be displayed in the column. No color is selected by default, that is, the color entered under the Section tab determines the color of the column text.

Cost Center

Enter a cost center or an interval of cost centers. Use the PopUp function to see which are registered. The field can be used to display data from only one or several cost centers in the section, instead of the account as a whole. This field is only displayed if the column type is Database (num).

Cost Unit

Enter a cost unit or an interval of cost units. Use the PopUp function to see which are registered. The field can be used to display data from one or several cost units instead of the account as a whole. This field is only displayed if the column type is Database (num).

Project

Enter a project or an interval of projects. Use the PopUp function to see which are registered. The field can be used to display data from only one or several projects in the section, instead of the account as a whole. This field is only displayed if the column type is Database (num).

Preview

At the very bottom of the Details section you can see a preview of the report's column layout. The columns are here displayed with the column headings, column positions and column widths that have been entered for each column in the Overview section. A ruler graded in centimeters is shown above the column headings.

of