In row definitions, the numbers or labels in the Row Codecell identify each line in the row definition. You can specify the row code to refer to data in calculations and totals.
Row code requirements
A row code is required for all rows. You can mix numeric, alphanumeric, and unset (empty) row codes within a row definition.
The row code can be any positive integer (below 100,000,000) or a descriptive label that identifies that row. A descriptive label must adhere to the following rules:
-
A descriptive label must begin with an alphabetical character (a through z or A through Z) and can be any combination of numbers and letters up to 16 characters.
Note A descriptive label can use the underscore (_) character, but no other special characters are allowed.
-
A descriptive label cannot use any of the following reserved words: AND, OR, IF, THEN, ELSE, PERIODS, TO, BASEROW, UNIT, NULL, or CPO, RPO.
The following are examples of valid row codes:
-
320
-
TL_NET_INCOME
-
TL_NET_94
Specify a row code in a row definition
To specify a row code, open a row definition in Report Designer, and then type the new value into the cell in the Row Codecolumn.
To reset numeric row codes, complete the following steps:
-
In Report Designer, click Row Definitions, and then open the row definition to modify.
-
On the Editmenu, and click Renumber Rows.
-
Specify the new values for starting row code and row code increment.
Note When you renumber row codes, Management Reporter automatically updates TOT and CAL references. For example, if a TOT row refers to a range that starts with row code 100 and you renumber starting with 90, the starting TOT reference changes from 100 to 90.
You can reset the numeric row codes to equally spaced values. Management Reporter renumbers row codes that begin with numbers, for example, 130, 246, but does not renumber row codes that begin with letters, for example, INCOME_93, TP0693.