Options

  1. Click the Options tab in the Financial Table Rows (FTR) dialog
  2. Specify this information:
    Column Change

    Use this to change the value for the row in a certain type of column. You can show balance amounts in columns originally designated as year-to-date or period, convert balance amounts to period amounts, or show year-to-date amounts in columns originally designated as balances.

    Underscore

    The type of underlining to be used on the row type. On a Total row, select Row Totals to underline the totals.

    On row types T2 Total to T7 Total, you can select No to suppress underlining before the total. On a T1 Total, select No to suppress underlining both before and after the total on row type T1.

    Note:  If a Table Column type of Heading exists with a Column Basis set to Row Description, any underscores are overridden by the contents of the Row Name specified in Table Rows.
    Offset Column

    The number of columns to be offset on the page when printing the contents of this row. Leave this blank if you do not want the row to be offset.

    Reverse Sign

    This is normally left blank. If selected, this option deducts the row values from the row totals before they are printed.

    Exclude from Printing

    This excludes the row from printing, but still includes the row values in the totals. This is useful for Statistics rows that are not reported on in their own right but are used in calculations for subsequent rows.

    Note:  If a T1-T7 total row is excluded, the total and those above it are set to zero.
    Report Code

    This determines whether the relevant code is printed alongside the name or description in the headings of the report. If a range of codes is used, the From code is printed in the table column which has the column basis Row Code. If you have set the Break Out Details option, the code is shown against each row in the range.

  3. Save your changes.