Home > Connector > Data Containers > Adding a Graphical Join Container

Adding a Graphical Join Container

Sage Intelligence Reporting supports the use of a Graphical Join as the source for Data Containers.

Method

1. In the Connector add a new Container to your Connection.
2. When the Select the Container Type window appears, select Graphical Join.



3. Click OK.
4. Enter a descriptive name for the container.
5. Click OK to complete adding the container.
6. Select the newly created container and in the properties window, click Graphical Join tool.
7. Select the tables that you wish to have participate in this graphical join. Join the tables by dragging primary fields in one table onto the secondary fields in the next table.
8. Once you have added the tables and joins that you require click Apply.
9. Right-click on the new Container and select Add Expressions. When prompted for the expression type to add, select Data Fields.
10. The list of fields that the view holds will appear. Select those fields which you would like to be available for reporting on and click OK.

The Container is ready to be used in reports.