Modifying the Joins Between Data Resources
When you create a business view, you need to create joins between the data resources you have selected to use for the business view to define the relationships between them. Logi JReport allows you to join data resources that come from different connections and this type of joins are called distributed joins.
To modify the joins between data resources in a business view:
- In the Business View Editor, select Join on the toolbar or select Menu > Tools > Join. The Query Editor appears.
- Add more data resources if needed and then select the columns in the added resources to use in the business view.
- Set up the joins between the data resources, then select OK to return to Business View Editor.
The newly added data resources will be displayed in the Resource Objects panel in the Business View Editor. You can then add them as view elements to the business view or use them in hierarchies.