Enforce Join¶
For reports that use an ODBC data source, an SQL statement is prepared for fetching the data set. The table below explains the influence of 'Enforce Join' on the SQL query.
| Enforce Join | Description |
|---|---|
| Not Enforced | The join is only executed if the main table as well as the child table are in the SQL query. |
| Enforced From | The join is forced when the child table is in the SQL query. |
| Enforced To | The join is forced if the main table is in the SQL query. |
| Enforced Both | The join is forced if the main table or the child table are in the SQL query. |