Show group name even with no records

[morg59jeep]

I have a report that has different sorting and grouping levels. The group names come from a group name table.
How do I get the report to show a group name in the header for a group that does not have any records? It works fine for any groups that have at least one record but I need it to show empty groups so that we know they are empty.

 

[Lilliabeth]

In the underlying query, change the join type to outer.

 

[morg59jeep]

Where do I change the join type. I cannont find it.

 

[Lilliabeth]

Right-click on the join line and choose Join Properties. Choose the option that will display all the records from the group name table.
OR
Go to the SQL and change INNER JOIN to LEFT JOIN