data from an application are being exported to an Access mdb and tables from the mdb serve as the data source for the report.  Each row of data includes a column that may contain more than one name and the desire is to display a separate row in the report for each name in that column.

 

Proposal: 

Create a formula (WhileReading) that begins by using Crystal's Split function to break the name column into an array. Then give the formula the value of the first element in the array.

now create a second formula; create the array; test the array length; if the length is > 1 then give this formula the value of the second element in the array.

You would need as many formulas as you could possibly have names in that column.

Now you can suppress all your detail lines and  use each of your formula as a grouping condition and suppress the group when the formula returns a null (or some token value) indicating there is no name for that formula.

 

Make sense?