Table Options

The Table tab contains options that enable the user to specify the behavior and contents of the Table form.

The following table describes the options available on the Table tab.

Option Description
Inherit comments from FD When this tick-box is selected, newly added columns inherit any comments from their corresponding data items in the FD.
Show logical order transform When selected, the LogicalOrder transform is available in the Properties pane (Column Transform option), in the table form.
Expand OCCURS into rows or columns Determines whether columns for repeating data items are added as rows or flattened as columns.

There are four possible states that may be selected for this option:

  • Ask - every time a column for a repeating data item is added the user will be prompted to select whether to add the data item as multiple rows or multiple columns. This is the default.

    Note that if the repeating data item has a subscript, the Subscripted Data Item dialog box will appear when adding selected columns to a Table Definition. This gives the option of using multiple rows or flattening the data items by using multiple columns.

  • Use multiple rows - always use multiple rows.
  • Use multiple columns when subscript has conditions - use multiple columns if the repeating data item's subscript has conditions. If there are no conditions, it will use multiple rows.
  • Use multiple columns - always use multiple columns.
Allow adding filler as a column Controls whether FILLER data items are added as a column.

There are three possible states that may be selected for this option:

  • When default column name is not Filler - FILLER data items can be added to a Table Definition as a column. The data items will appear in the Add Columns to Table Definition grid if it has a Default Column Name. This is the default setting.
  • Never allow - FILLER data items cannot be added as a column.
  • Always allow - FILLER data items can be added as a column.