Click ‘Advanced’ in the Toolbar drop-down menu to open the Advanced Options window. This window allows you to specify additional information about how the Data Categories relate to each other.
If a report has two or more Data Categories, then information will only appear if it matches both categories. Using the check boxes, specify information that you want displayed even if it only exists in one of the Data Categories.
For example if a report has two Data Categories, Orders and Customers, then only customers who have made orders will appear. By checking the appropriate box you can include information on customers that have not made orders.
If you have been given permissions, additional options are available in the Advanced Menu.
When you click the 'Add' or 'Edit' buttons the Report Join Menu will appear. In this menu you can create or modify a Join for the report.
Ex. In the image below Customers.CustomerID corresponds to Orders.CustomerID so both Fields are at the top of their sections.