Row Maintenance

---

Use this form to specify what you want to display vertically on the report; it is a key component of web reporting. You must have set up relevant trees in GL Account Tree Maintenance before defining your report rows.

There are three primary row types:

• Comment - The text you want to appear in the report row - primarily used for headings.
• Tree - A detailed line that will contain values; it must relate back to a standard the and branch.
• Total - This is used to sum detailed (tree) lines. You can also include some minor calculations, such as dividing or multiplying by a constant value. For example, to calculate expenses as a % of sales.

Code

Enter a name for the row structure, up to 30 alphanumeric characters long.

Description

Enter an extended description for the row structure.

Tree

Select the GL Account Tree used to report specified rows.

Once selected, the tree becomes read-only. If you have selected an incorrect tree, a new Row Maintenance must be created.

Default Style

Select a style to default to new rows as they are added. This can be overridden by selecting a style at the row level.

Entering Rows

Row No

Enter a manual number to determine the order in which the rows displays using WebView. It is advisable to leave gaps in your numbering so that you can add new rows between existing ones if necessary at a later time.

Line Type

Specify whether the row is a Comment, Tree, Account, Account Type, or Total row. The selection made will determine what additional information must be specified for the row.

Comment Row

Enter this to support a comment row:

• Style - Select the style format to apply to the comment.
• Caption - Enter the text (or space if applicable) to print on the comment line.

  The text does not wrap around and you cannot force a new line with CTRL-Enter. You can, however, create two comment lines to print a heading/comment that extends beyond the width of the web page.

• Calc/Branch/Account/Type - This is not applicable for a comment row.

Tree Row

A tree row is used to add figures/values to your report. The tree must relate back to the GL Account Tree selected on the main form.

Style

Select the style format to apply to report values.

Caption

Enter any text you want to appear on the row. This will identify the value that is being displayed within the row in relation to the selected tree branch.

Calc/Branch /Account/Type

Use Enter or double click to select a tree branch.

Account Row

Enter this to support an account row:

• Style - Select the style format to apply to the account.
• Caption - Enter the text to print on the row. This will identify the account.
• Calc/Branch /Account/Type - Enter the characters for your GL Account or range of Accounts. To choose all values for a particular segment, use an *. To select all values for one position within a segment, use a ?. For example, 10.*.* returns all accounts with 10 in the first segment. 10.*.1?? returns all accounts with 10 in the first segment and those where the last segment begins with a 1.

Account Type Row

Enter this to support an account type row:

• Style - Select the style format to apply to the account type.
• Caption - Enter the text to print on the row. This will identify the account type.
• Calc/Branch/Account/Type - Select the type of account to display, for example, Income, Expense.

Total Row

Enter this to support a total row:

• Style - Select the style format to apply to the report total value.
• Caption - Enter any text you want to appear on the row, to represent the total.
• Calc/Branch/Account/Type - Enter the detail of what is to be totalled or calculated. You can use the four standard numeric operators (+, -, * and /) and brackets to indicate the order in which calculations are performed.

  You cannot add up a range of rows. You must add each row to the formula independently.

Alternative Column Format

If a column format is specified here, the row displays using this format instead of the one defined at the report level.

Visible

This indicator can be used to specify rows to use for calculations, without actually displaying them on the report.

• Style Maintenance
• GL Account Tree Maintenance

---