Changes

Jump to: navigation, search

Using an Outer Join

169 bytes added, 20:51, 10 July 2019
no edit summary
{{Banner-UnderConstruction}}
 
 
 
==Overview==
This article will explain how to use the '''Outer Join''' option for when you are creating a [[Reports|report]] with multiple [[Report Recordsets|recordsets]]. This feature is applicable only for reports with '''[[Classic Report Builder - Column Settings|Builder Type - Classic]]''' (as opposed to our more recent and recommended option, the '''[[Report Builder (Neo)|Neo Report Builder]].'''
1. Click on the 9-square menu icon on the top right of your page.
 
210 + 200 + 250 = 660 + 100 = 660 +
:: {{Icon-Menu}} 
4. Click into the second tab labelled '''Recordsets.'''
:: [[File:Recordsets inner outer join.png|thumb|none|600px|border|Outer Join option available for fields found in the Recordsets tab]]===Example of Outer Join for Reports===
In this article you will modify the query to display companies where there are no contacts.
2,299
edits

Navigation menu