IMOS On-Prem - Adding Columns

View IMOS Documentation in the Help Center.

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.

Adding Columns to a Report

In the Tables pane, do the following:

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  next to the field name.

Selected columns appear in the left pane.

Adjusting Columns in a Report

In a report, you can make any of the following adjustments to columns:

• 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 Ascending, Sort Descending, or Clear Sorting.
  • Click the arrow on the field name in the Columns pane and click None, Asc, or Desc.
• To change the properties of a column, including Heading, Font, Background, and other formatting, click the field name in the Columns pane and edit the Properties fields.