I attached here source file that report is based on. Two groups are present first group is Club and second group is Club_Role.
One club could have up to 10 club roles.
My real name of groups is different than in the attached file, this is just example. In my case every club role has different name not Role1, Role2 ….
Club_ Role group could have more members, and report layout should be with two detail columns.
I need to show club role even if no member is in that group. Club_ Role group should be sorted on specific order.