When using outer joins to combine tables, the ordering
of tables can affect what data the report can return.
If multiple tables are used in the report, you may also need
to change which secondary tables are directly linked to the primary
table or change the relationships between secondary tables in the
data set.
- Open the Data Set window.
- To select a different table in the data set as the primary
table, right-click the table and select Set as Root.
When you set a new table as the root, or primary table, the
relationship between the table and the old primary table is broken,
resulting in the data set having two primary tables.
- To move a table beneath another to make it a secondary
table, drag the table onto the primary table.
The tables are automatically joined and the new table relationship displays on the Data
Set window.