It doesn't take a SQL expert to join tables using Sage Intelligence. The Graphical Join Tool in the Connector makes it fairly simple.
Oftentimes the data that we need for our reports comes from joining two or more different tables. The following process allows you to quickly join tables without having to know SQL, by just clicking and dragging a connection between the fields within a group of tables.
Before you use the Graphical Join Tool, it is best to have all your data requirements and know the tables and fields you are going to use. Here is the process:
It is recommend that you test your container after you have created your new join. You can do this by right-clicking on the container and choosing Check/Test from the context menu. If your graphical join is correct, you will receive an alert stating that your check succeeded. If not, you need to check your join, container and connection for any errors. You are now able to add expressions to your container.
If you need to add more tables to your join you can do this by selecting the Graphical Join Tool button again, and then selecting the Add Table button and repeating the process described above.
For answers to your questions, or more help with Sage Intelligence contact Equation Technologies today. We are a certified Sage partner and specialize in Sage 300 ERP.
Through a strategic partnership with Zap Data, Sage recently announced the launch of Sage Data & Ana...
SAGE ENTERPRISE INTELLIGENCE
4 Important Benefits To Note
With all of the data going into your Sag...
If you haven’t looked at the Report Designer for Sage Intelligence yet, you are missing out! Sage I...
United States: 533 2nd Street Encinitas, CA 92024
Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6
Phone: 866.436.3530 • E-mail: firstname.lastname@example.org