• Open the Crystal Report.

    • Select Database, Database Expert from the menu bar.  

    • Select the Links tab and maximize the screen.  

    • One at a time, highlight the link between each table and click the Link Options... button on the right.  

    • Change the Join Type from Inner Join to Left Outer Join.  Leave all other defaults.  

    • Click OK.