Open and save your document

1. Select the document you want to edit and choose Edit.
2. On the menu bar, select Report, then press Report Properties.
3. Enter a new report name and description.
4. Press OK, then on the menu bar select File.
5. Press Save As and enter a new file name.

 

Add a new table

1. In Report Designer, on the menu bar select Report, then press Joins.
2. In the Toolbox pane, select the table that you want to add, for example, INVOICE.
3. Select and drag the table into the central pane near to the existing table you want to join to.

Create a join between tables

1. In Join Editor select the table that you want to be the parent table, for example, AUDIT_HEADER.
2. In the parent table, select the variable that you want to join, for example, INV_REF_NUMERIC.
3. Choose the table that you want to be the child table, for example, INVOICE.
4. In the child table, choose the variable that you want to join, for example, INVOICE_NUMBER.
5. Select and drag the highlighted variable from the parent table to the highlighted variable in the child table. For example, click and drag INV_REF_NUMERIC from the AUDIT_HEADER table to INVOICE_NUMBER in the INVOICE table.

The join is created and the parent table is identified by a key.

 

Set the join type

1. In the Join Editor, select the join between the two tables.
2. In the Properties pane, in the Join Type dropdown select the type you require, for example, Parent Outer.
3. In the Properties pane, in the Conditional Join Type dropdown click the same type, then press OK.