Automatics Joins
XLReport will add relationship joins automatically if detected in your database schema.
- You can edit the relationship joins or add them manually.
Create Joins manually
- Select the field to join from one table and drag it to the field to join of the another table.
This will create an INNER join.
Edit Joins
- Double click the join line.
- Choose between LEFT, RIGHT and INNER joins.
Remove Joins
- To remove a join select the join line, right click and select Remove .