/visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets section 2026-02-19T17:09:06+01:00 # View and edit column sets /visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/view-and-edit-the-column-sets-overview page To view the parameters of existing column set, you can use navigation buttons in the Unit sets (CS206030) window, or select the column set code using the Code selector in the Column set window area. 2026-02-19T17:09:06+01:00 # View and edit the column sets - overview To view the parameters of existing column set, you can use navigation buttons in the Unit sets (CS206030) window, or select the column set code using the Code selector in the Column set window area. For more information: [Unit sets (CS206030)](/visma-net-erp/help/general-ledger/general-ledger-windows/unit-sets-cs206030/). The navigation buttons allow moving to the first, next, previous and the last column set in the collection of available column sets. By defining the column sets, you can specify what columns will be included in the analytical report. The steps to be performed for the column set modification are similar to the ones used to create a new column set. ## Topics + [Operations with column sets](/visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/operations-with-column-sets/) + [Define the columns to be included in the column set](/visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/define-the-columns-to-be-included-in-the-column-set/) /visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/operations-with-column-sets section Column sets are used to define the structure of the analytical reports, including the data to be displayed in the report columns, and the report layout parameters. 2026-02-19T17:09:06+01:00 # Operations with column sets Column sets are used to define the structure of the analytical reports, including the data to be displayed in the report columns, and the report layout parameters. These parameters can be used in multiple reports that use similar data selection rules and a similar report layout structure. To specify the set of columns for a group of analytical reports or a single report, you can create new column sets or modify existing ones. To remove the set of columns associated with the reports that are no longer used, you can delete the column sets associated with them. To perform these operations with the column sets, use the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window of the [About the analytical report manager](/visma-net-erp/help/general-ledger/manage-analytical-reports/about-the-analytical-report-manager/). ## Create a new column set 1. Click **** in the **Column set** control panel. 1. Enter the code of the column set in the **Code** field. 1. Enter the column set description in the **Description** field. The column description is not displayed in the printed report and is used only to add a descriptive comment to the column set. 1. Click **** to save the created column set. The columns and data filters can be added to the created column set later. The column set code must be unique within the whole system. The length of the unique column set code is limited by the range of 1 to 10 symbols. The allowed symbols are only digits and letters. ## Modify the existing column set 1. Select the existing column set code in the **Code** field in the Column set area of the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window, or use navigation buttons in the control panel to find the required row set. 1. Change the column set attributes as required. 1. Click **** in the **Column set** control panel to save the changes. ## Delete a column set 1. Display the column set to be deleted in the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window. 1. Click **** in the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window control panel. ### Parent topic [View and edit the column sets - overview](/visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/view-and-edit-the-column-sets-overview/) Related concepts [About the analytical report manager](/visma-net-erp/help/general-ledger/manage-analytical-reports/about-the-analytical-report-manager/) [Column sets - overview](/visma-net-erp/help/general-ledger/manage-analytical-reports/column-sets/column-sets-overview/) Related reference [Report definitions](/visma-net-erp/help/general-ledger/general-ledger-windows/report-definitions-cs206000/) /visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/define-the-columns-to-be-included-in-the-column-set section To define the columns included in the column set, you can perform the following operations with the columns: 2026-02-19T17:09:06+01:00 # Define the columns to be included in the column set To define the columns included in the column set, you can perform the following operations with the columns: + Add new columns to the column sets + Set the attributes for each column in the column set + Delete the columns from the column set To perform the operations with the columns in the column set, use the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window. The **Columns** table in this window displays the existing columns and their attributes. ## Create a new column To create a new column in the column set, perform the following steps: 1. Click ****. 1. Specify the new column attributes in the relevant columns of the **Columns** table. 1. Click ****. ## Add a header to the column To add a text description for a single column or a column range in the printed report, define a header for a column or a columns range. The **Headers** section of the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window allows you to add the headers to the reports and define in which rows the headers should be printed. The **Headers** section of the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window provides the tools to define the headers for a single column or a column range, and insert the headers in the rows specified by the **Printing group** attribute in the **Headers** table. The header for a column or a columns range should be defined after the columns are added to the column set. Every header can be assigned its printing style. You can add, delete, and change the order of the headers in the **Headers** table, and copy the printing style defined for a certain header to apply it to another header in the analytical report. To add a header for a single column or a columns range, perform the following steps: 1. Click ****. 1. If the header should be printed in a specific row, in the **Printing group** column of the **Headers** table enter the printing group code (the same code should be entered in the **Column group** column for the relevant row). 1. Enter the header text in the column where the header should appear. 1. Use the lookup control in the column to set the columns range for the header printing and define the printing style. By default, the columns range is limited by a single column where the header text is entered. To set the columns range, enter the codes of the start column and the end column in the range. ## View and edit the column attributes The attributes of each column are displayed as the values in the **Columns** table in the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window. You can edit these attributes for the selected column by changing the values in the relevant rows of the **Columns** table. To change a specific column attribute, select this attribute and change its value. After all necessary changes to the column attributes are performed, save the changes by clicking **Save** in the **Column sets** control panel. Unsaved changes will be cancelled after navigation to another page. By changing the column attributes, you can define the data selection, processing and formatting rules for the data to be included in this column. For every new column added to the column set for the specific report, specify the column attributes. ## Delete a column To delete an existing column from the column set, perform the following steps: 1. Select the column you want to delete. 1. Click ****. 1. Click ****. ## Use the column set in the analytical reports Once you define a column set, you can use this column set in any analytical report you configure using the [Report definitions (CS206000)](/visma-net-erp/help/general-ledger/general-ledger-windows/report-definitions-cs206000/) window. ### Parent topic [View and edit the column sets - overview](/visma-net-erp/help/general-ledger/manage-analytical-reports/design-analytical-reports/view-and-edit-column-sets/view-and-edit-the-column-sets-overview/) ### Related concepts [About the analytical report manager](/visma-net-erp/help/general-ledger/manage-analytical-reports/about-the-analytical-report-manager/) [About column attributes](/visma-net-erp/help/general-ledger/manage-analytical-reports/column-sets/column-attributes/) [About printing styles](/visma-net-erp/help/general-ledger/manage-analytical-reports/printing-styles/)