Showing even empty subcategories
I have MainTable, and a SubTable (contacts) that normally shows in a portal. I can make a report to show each person in the MainTable and show the contacts that go with them but I get one of two undesired reports. If I base it on MainTable it only shows the first contact. If I base it on the ContactTable then I get a line for each Contact but any person in MainTable who doesn't have any contacts doesn't show up in the report at all. If a person doesn't have any contacts I want it to show their name as a category header and show there are no contacts so we know that. Thanks.