In Crystal Report I have two groups.
Group 1 is Club Name.
Group 2 is Club Role.
Then I have members in those club roles.
User wants to see always all 10 Club Role groups on report, does not matter if there is member in or not in group.
If there is no member for Club Role group then show Club Role Title and empty space for detail records.
I can not insert new query or table in report or do Union on existing tables.