About data filtering criteria

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.

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.

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.