Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
After you define Report Properties, the Report Designer panel appears with a list of tables containing the 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
On the Report Designer panel, do the following:
- To select a table, click it.
Note: To see all tables in the Report Designer, click Show All Tables. - To add columns, use any of these methods from the list of fields in the Report Designer panel:
- 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, 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 + at the top of the list.
- To join a table, after selecting one of the primary tables, hover over it and then click + .
- To join a field, click next to the field name.
- To search for a field in the selected table, type its name in the Search field at the top of the list.
- To save the report, click << Report at the top of the list and then click Save.
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 change the properties of a column, including Heading, Font, Background, and other formatting, click the field name in the Report Designer panel and edit the Column Properties fields.