Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Getting Started with IMOS On-Prem
Getting Started with IMOS On-Prem
nopaneltrue

After you define Report Properties, the Tables pane appears with a list of tables, which contain fields that you can add as columns to your report. A list of all tables is available in the Data Map.

...

  1. To select a table, click it.
    Note: To see all tables in the Report Designer, click  and then click Show All Tables.
  2. To add columns, use any of these methods from the list of fields in the Tables pane:
    • To search for a field in the selected table, type its name in the Search field at the top of the list.
      • To clear the Search field, press Esc.
    • To use a field as a column, drag it to the Columns pane or select its check box.
      Note: Watch for duplicate fields.
      • To create a range of commencement dates and completion dates of the voyages in your database, use the Voyage Range GMT field from the Voyage Table.
    • To add a custom column, click New at the top of the list.
    • To join a table, after selecting one of the primary tables, click the + button.
    • To join a field, click Image Modified next to the field name.

Selected columns appear in the left pane.

...

  • To show or hide columns in the report, right-click a column heading and hover over Choose Columns. A list of columns appears and you can select the ones you want to see. Only columns that were added to the report in Design Mode appear in this list.
  • To change column sequence, drag the column heading to where you want it in either the columns themselves or the Columns pane.
  • To sort by a column, do one of the following:
    • Click the column heading to Sort Ascending. Click again to Sort Descending. Click again to Clear Sorting.
    • Right-click the column heading and click Sort AscendingSort Descending, or Clear Sorting.
    • Click the arrow on the field name in the Columns pane and click NoneAsc, or Desc.
  • To change the properties of a column, including HeadingFontBackground, and other formatting, click the field name in the Columns pane and edit the Properties fields.