2,299
edits
Changes
no edit summary
4. The '''New Report '''page is displayed, with fields for you to fill out.
:: [[File:New report pagReports multiple tables new.png|700px|border]]
For this example exercise, fill out the following fields with the corresponding information:
:* An '''inner join''' displays the intersection between the two tables.
::** This is the most common type of join used, and is the default join type when you [[Adding a Table to a Report|add tables to a report]].::** When you join the company table and the contact table with an inner join, the report will find the matching record(s) from the contact table related to each company.::** If no match is found, the record from the company is not included in the results.::** If multiple results are found in the contact table, the company information will be repeated. :
:* An '''outer join''' is very different from an inner join. Instead of limiting results to those in both tables, it limits results to those in the "left" company table.
::** This means that if there are no records in the contact table, a row in the report will still be returned for that company, but with NULL values for each column from contact.
1. Open the '''Report Builder'''.
::* The '''Field''' list now contains fields from both tables.
3. '''Build''', '''save''', and '''preview''' the report.
::* No company details will be displayed if there are no contacts.
{{PrevNextStart}} [[Creating a Public – Internet Enabled Report]]
{{PrevNextMid}} [[Using an Outer Join]] {{PrevNextEnd}}
[[Category:Reports]]
