The Column Definitions tab in the Crosstabulation Definition Editor allows you to create and edit the columns required to create the definition.
Each column within the Crosstabulation Definition Editor represents the make up of each row in the definition itself. Each column has the following settings:
This determines whether the column contains positive or negative values in the report output. Positive values are given to the items that are sold and generate an income. Negative values are given to outgoings or costs to the business.
This allows you to define which column this item will be output into. By default, output columns are numbered 1 to n (where n is the number of columns defined).
Allows you to choose which column type to display in the required data. There are a large number of these to suit all types of definition you may want to create.
This allows you to define the data that is used in the column, built using the column type you have selected. See specific column codes for more information.
This allows you to define an optional column header which will be displayed on report output. See column headers for more information.
How to Add a Column
Click Add to create a new column at the end of the definition. To insert before the current column, click the drop-down arrow and select Insert Before. Move through the selections above to create a complete definition.
Deleting a Column
To delete a column that is no longer required, select it and press Delete on the toolbar. Make sure that you definitely want to delete this column as this process is irreversible.
By selecting a column and pressing Properties, you will be able to view the Structure of that column and apply any advanced options required to it.
Copy and Paste Columns
Single and multiple columns can be copied and pasted within a Crosstab Definition by selecting the column/s and right-clicking on the mouse.
Single columns can be moved up and down within a Crosstab Definition using the up and down arrows to the right of the column definition table.
Be aware that you might need to revise any custom output column numbers after moving columns.