Adding Join Conditions

The Add/Modify Join Condition dialog allows you to select the Relational Fields, which connect to other applications or auxiliary tables. You can pull in the additional data from these sources into your report. In addition, you can choose to filter your report results based on the values in these related items.

Important: Join conditions are not supported in the Editable Grid template.

The Add/Modify Join Condition dialog displays after clicking Add on the Create or Modify report screen.

To set a Join Conditions on the Add/Modify Join Condition dialog:

Choose the Relational Field from the drop-down list. These Relational Fields occur in the application where you are creating the report.
(Optional) Change the display name of this Join condition by modifying the text in the box. Choosing a unique display name helps to distinguish when you have multiple join conditions from the same application or auxiliary table.
Note: The display name appears in the Solution table drop-down list on the report creation screen.
To limit report results to only items that include data in this relational field, select This related item filters the report results.
To limit report results based on data in the related item, select This related item filters the report results and add a filter. The filter behaves similar to the Search Filter found on the creating report page; however, some search options are not available on the Join search filter.
Note: You must have privileges to create/modify a report in the referenced table to add or modify a search filter. If you attempt to edit a pre-existing report which contains a join to a table which you do not have privileges in, you are limited as follows:
- You cannot modify the existing join. You can either delete the join or leave it alone.
- You cannot choose to display additional columns for the table. The Alias name is disabled in the drop-down. You will be able to change the display of existing columns.

Adding Join Conditions

Related Topics