Sdílet prostřednictvím


Specify a row code in a row definition

In row definitions, the numbers or labels in the Row Code cell 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 in 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 follow these rules:

  • 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

    Can use the underscore (_) character, but no other special characters are allowed.

  • Cannot use any of the following reserved words: AND, OR, IF, THEN, ELSE, PERIODS, TO, BASEROW, UNIT, NULL, or CPO, RPO.

The following examples are valid row codes:

  • 320

  • TL_NET_INCOME

  • TL_NET_94

Change a row code in a row definition

  1. In Report Designer, click Row Definitions, and then open the row definition to modify.

  2. In the appropriate row, type the new value in the cell in the Row Code column.

Reset numeric row codes

  1. In Report Designer, click Row Definitions, and then open the row definition to modify.

  2. On the Edit menu, click Renumber Rows. The Renumber Rows dialog box opens.

  3. Specify the new values for starting row code and row code increment. You can reset the numeric row codes to equally spaced values. However, Management Reporter renumbers row codes that begin with numbers, for example, 130, 246, but it does not renumber row codes that begin with letters, for example, INCOME_93, TP0693.

    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 rows starting with 90, the starting TOT reference changes from 100 to 90.

See Also

Row definition