Create Reports - the Column Definition Tab

You can use this tab to define the report’s columns.

The same dimensions you moved to the Column Definition list box on the Axes tab now appear as columns in the Column Definition tab. These columns contain information on exactly what you enter on each row, for example period or actuality.

All information in the Column Definition tab can be saved under a separate name and then be copied or reused in subsequent reports.

Note: The texts entered in the Group Text and Local Text columns on the Column Definition tab will appear in the system columns section on rows 27 to 30. When the report layout is updated in the Create Reports window, these cells will be updated according to the Group Text or Local Text ettings. Columns on rows 27-30 that are not system columns may be used for other texts or functions. For more information about system columns, see System Rows and Columns and Functionality.

Example 1

On the Axes tab, you have selected the Company dimension in the Available list box. The Column Definition tab displays the Company, Expand Company, Consolidation Type and Expand All Levels columns (local text and group text will always appear, regardless of selected dimensions). In the Company column you can enter which companies or groups the report should contain. In the Consolidation Type column you can enter which consolidation type should be displayed. Select the Expand One Level column, if you also want to display the underlying companies one level down when you generate the report. Select the Expand to Lowest Level column, if you also want to display all underlying companies when you generate the report.

Text Strings/ Variables

You can enter the row texts for each row in both the local language and the group language. They can contain either one or more text strings or one or more variables. There are a number of variables for loading names and texts from the database. If you want to specify a number of variables, you can use the concatenate function.

Example 2

"=Concatenate(cc.fAcc()," ",cc.fAccName())".

For more information, see The Difference between Functions and Parameters.