Changes

Jump to: navigation, search

Reports Based on Multiple Tables - Overview

3 bytes added, 14:41, 30 August 2013
Inner and Outer Joins
:*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'''.
:2. Add the '''following fields''':
:[[Image:Reps98.png]]
:*The '''Field''' list now contains fields from both tables.
:3. '''Build''', '''save''', and '''preview''' the report.
:[[Image:Reps97.png]]
8,849
edits

Navigation menu