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

Adding a Graphical Join Container

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

Adding a Graphical Join Container – Step by Step

1. In the Connector add a new Container to your Connection.
2. When prompted to Select the Container Type choose Graphical Join.



3. Enter a descriptive name for the container.
4. Press OK to complete adding the container.
5. Select the newly created container and in the right hand side of the screen select the Graphical Join tool button.
6. 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.
7. Once you have added the tables and joins that you require click Apply to complete adding the graphical join container.
8. Right click on the new Container and click Add Expressions. When prompted for the Expression Type to add choose Data Fields.
9. The list of fields that the View holds will appear. Select those fields which should be available for reporting on and click OK.

The Container should now be ready to be used in Reports.