Create a formula named Solicitor Group as follows:

StringVar Array solicitors;
NumberVar i := 1;
StringVar name;

if instr({CnPrProp_1.CnPrProp_1_Solicitors},"; ") > 0 then
    (
    // Solicitor name in position 1
    if not(split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[1] in solicitors) then
        (
        redim preserve solicitors[ubound(solicitors)+1];
        solicitors[ubound(solicitors)] := split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[1];
        name := split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[1];
        )
    // Solicitor name in position 2
    else if not(split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[2] in solicitors) then      
        (
        redim preserve solicitors[ubound(solicitors)+1];
        solicitors[ubound(solicitors)] := split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[2];
        name := split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[2];
        )
    // Solicitor name in position 3
    else if ubound(split({CnPrProp_1.CnPrProp_1_Solicitors}, ";"))>2 and not(split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[3] in solicitors) then      
        (
        redim preserve solicitors[ubound(solicitors)+1];
        solicitors[ubound(solicitors)] := split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[3];
        name := split({CnPrProp_1.CnPrProp_1_Solicitors}, "; ")[3];
        )
    )
else if instr({CnPrProp_1.CnPrProp_1_Solicitors},"; ") = 0 then
    if not({CnPrProp_1.CnPrProp_1_Solicitors} in solicitors) then
        (
        redim preserve solicitors[ubound(solicitors)+1];
        solicitors[ubound(solicitors)] := {CnPrProp_1.CnPrProp_1_Solicitors};
        name := {CnPrProp_1.CnPrProp_1_Solicitors};
        )
    else
        name := {CnPrProp_1.CnPrProp_1_Solicitors};
name;


 

  1. Go to Insert > Group
  2. Select to group on the Solicitor Group formula created above in ascending order
  3. Go to Insert > Subreport, and create a subreport that will house the desired information in the Details section (ex: Proposal Date/Name, Solicitor, etc)
  4. Insert the Subreport into the Group Header section (grouped on the Solicitor Group formula) and expand it to the full width of the section
  5. Right-click on the Subreport and select Change Subreport Links
  6. Select to link on the Solicitor Group formula
  7. In the bottom right, link it to Proposal Solicitors field
  8. Click OK
  9. Right-click on the Subreport again and select Edit Subreport
  10. Go to Report > Select Expert > Show Formula > Formula Editor
  11. Delete the current formula and change it to be: instr({CnPrProp_1.CnPrProp_1_Solicitors},{?Pm-@Solicitor Group})>0
  12. Click Save and Close, then OK
  13. Insert a Group into the subreport to sort proposal based on desired criteria (ex: Proposal Name or Proposal Date)
  14. Suppress all blank sections not needed in the subreport
  15. Return to the Main report, right-click on the Subreport and select Format Subreport
  16. On the Common tab of the Format Editor, unmark Keep Object Together
  17. Click OK
  18. Preview the report and format the Subreport as desired