Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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:
- To select a table, click it.
Note: To see all tables in the Report Designer, click and then click Show All Tables. - 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.
- To search for a field in the selected table, type its name in the Search field at the top of the list.
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:
...