/visma-net-erp/help/general-ledger/manage-analytical-reports/data-source section 2026-02-19T17:09:06+01:00 # Data source /visma-net-erp/help/general-ledger/manage-analytical-reports/data-source/data-source-overview page 2026-02-19T17:09:06+01:00 # Data source - overview The data source defines and applies the data filtering criteria to select the data that will be used in the report. You include the selected data in the report in the following ways: + For the row, by applying data filtering criteria to the report rows in the **Data source editor** dialog box. You invoke this dialog box from the **Data source** **column** field in the [Row sets (CS206010)](/visma-net-erp/help/general-ledger/general-ledger-windows/row-sets-cs206010/) window). + For the column, by applying data filtering criteria to the report columns in the dialog box. This dialog box is invoked from the **Data source** field in the [Column sets (CS206020)](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/) window). + For the unit, by applying data filtering criteria to the rows and columns included in the unit in the **Data source editor** dialog box. You invoke this dialog box from the **Data source column** field in the [Unit sets (CS206030)](/visma-net-erp/help/general-ledger/general-ledger-windows/unit-sets-cs206030/) window. + For the data source defined for the entire report, by applying additional data filtering criteria to the report rows and columns. You do this by setting the data source parameters in the [Report definitions (CS206000)](/visma-net-erp/help/general-ledger/general-ledger-windows/report-definitions-cs206000/) window. Thus, you can define the data filtering criteria for a separate row, column, or unit included in the report, or for the whole report at once. [About the analytical report manager](/visma-net-erp/help/general-ledger/manage-analytical-reports/about-the-analytical-report-manager/)

Related pages

Concepts

• About data filtering criteria

/visma-net-erp/help/general-ledger/manage-analytical-reports/data-source/about-data-filtering-criteria page Data filtering criteria specify how the data will be selected from the database. 2026-02-19T17:09:06+01:00 # About data filtering criteria Data filtering criteria specify how the data will be selected from the database. These criteria can be defined for the whole report, for a unit, or for any specific row or column in the report. Usually, the criteria defined for the rows and columns reflect the report structure: They specify how the report data will be grouped in rows and columns. Data filtering criteria specified for a report or individual row or column in the report include the following: Specific group of accounts and subaccounts : The specific group of accounts and subaccounts used to limit the volume of data to be included in the report Specific period : The limited time period used to set the time frame for the data to be used in the report Type of amount : The specific amount type to be used in the ARM report (in the whole report or in a separate row or column), such as the beginning balance amount or ending balance amount ## Specific group of accounts and subaccounts To filter out the data that is not related to the specific account and subaccount, or set the range of the accounts and subaccounts to be used for data filtering criteria in the report, you should define the account and subaccount ranges. To specify the group of accounts and subaccounts to be included in the report, you can use the **Account class** value. To set additional limitations and select the specific accounts, subaccounts, or both as data filtering criteria, you should set the values of the **Start account** and **End account** parameters. If the accounts specified in the **Account class**, **Start account,** and **End account** fields have no common data, **Null** values will be displayed in the report rows, columns, or both. Note: You can use the denominated accounts for retrieving amounts in a foreign currency. ## Specific period To set the specific periods for the data to be included in the report, specify the **Start period** and **End period** parameters. The data related to the periods not included in the selected one will be filtered out and not included in the report. ## Amount type To define the type of amounts that should be used in the report lines (displayed or used in calculations), you should specify the **Amount type** parameter in the **Data source editor** dialog box. The following types of amounts can be selected: **Turnover**, **Credit**, **Debit**, **Beg balance**, **Ending balance**. These types of amounts can be specified for use in the whole analytical report or for a separate row or column. You can also use the amounts in a foreign currency retrieved from the denominated accounts by specifying one of the following parameters: **Curr. turnover**, **Curr. credit**, **Curr. debit**, **Curr. beg. balance**, **Curr. ending balance**. If the **Amount type** parameter is not specified for any report item (such as row or column), the **Null** value will be displayed in the report row or column. ### Parent topic [About the data source](/visma-net-erp/help/general-ledger/manage-analytical-reports/data-source/data-source-overview/) [About row attributes](/visma-net-erp/help/general-ledger/manage-analytical-reports/row-sets/about-row-attributes/) [About column attributes](/visma-net-erp/help/general-ledger/manage-analytical-reports/column-sets/column-attributes/) Related reference [Report definitions - reference information](/visma-net-erp/help/general-ledger/general-ledger-windows/report-definitions-cs206000/) [Row sets - reference information](/visma-net-erp/help/general-ledger/general-ledger-windows/row-sets-cs206010/) [Column sets - reference information](/visma-net-erp/help/general-ledger/general-ledger-windows/column-sets-cs206020/)

Related pages

Concepts

• About the analytical report manager