Selecting the Data for a Table Row
The Row type on a financial table row definition controls the values printed on a report line by determining how the transactions are selected for the row. The transactions are summarized to provide the row values.
On a Row type you select a Row Basis. This is the primary selection criteria used to select transactions for the row. For example, you might choose account code, or an analysis dimension.
Choose the row basis selection criteria, and enter a code or range of codes for this criteria to determine the transactions required.
If you select a single account or selection code, you can print the account or code name as the description for the line. If you select a range of codes, you can enter a description to be used on the line.
Continuation Lines
If you want to include additional accounts or selection codes in the same line, you can use a Continuation row to identify the extra codes. You can define as many Continuation lines as you need, each one adding into the previous Row type.
This facility for adding accounts or codes, or ranges of accounts or codes, to another account, code, or range means that, however you design your chart of accounts, you can extract the financial data you need onto a report.
Summarizing or Detailing the Codes
By default, a single Row type row produces in a single line on the report. If you choose transactions for a range of accounts or codes for a row, and/or include Continuation rows, all of the transactions are summarized on a single line in the report.
Alternatively, you can select the Break Out Details option on the Row type to print all of the accounts or codes selected in the Row type on the report. A separate report line is printed for each account or code. These lines form an extra level of subtotal.
Using Selection Criteria to Restrict the Transactions Selected
Sometimes you might want to further restrict the transactions you include on a line. You can identify up to three additional selection criteria that apply within the Row Basis. They are used to narrow down the transactions selected for the primary accounts or codes.
For example, you might want to show the total marketing costs for each of three divisions on three separate rows on the report. You would select Ledger Transaction Analysis Dimension as the selection dimension, and enter the analysis code ranges as follows:
| Line Type | Row Name | Row Basis | Row Basis Selection From/To | Selection Dimension | Code From | Code To |
| Row | Marketing Costs - Division 1 | Account Code | 40000-49999 | Ledger Transaction Analysis Dimension 1 | 1 | 1zzz |
| Row | Marketing Costs - Division 2 | Account Code | 40000-49999 | Ledger Transaction Analysis Dimension 1 | 2 | 2zzz |
| Row | Marketing Costs - Division 3 | Account Code | 40000-49999 | Ledger Transaction Analysis Dimension 1 | 3 | 3zzz |
Excluding a Code from a Range
You may want a row on a report to include a range of codes, except for an odd code in that range. You can, of course, set up a row for the first part of the range, then add a continuation line for the second part of the range.
Alternatively, you can use the Reverse Sign option to exclude a code. Define a single line for the whole range of codes, for example 10000 to 29999. Set up a continuation row for the code you want to exclude, for example for code 25600. On the continuation line set the Reverse Sign option. Account 25600 is initially included in the row total calculated by the first line, but the continuation row then subtracts it from this total. The printed result excludes account 25600.