I am not sure how to achieve the following design of one of the sub reports.

In my record set there are 3 children and one adult. I need to display Adult’s name, Relationship to child1, child2, child3 in one line like this that can continue to next line. It requires children to be mentioned as 1, 2, 3 instead their Id:

Person Name: <person_name>           Relationship to (1):  <relationship>   (2):  <relationship>  (3):  <relationship>                                     

There can be many person and many children related to them. For Example:

Person_ID        Person_Name        Child_id                Relationship

1                      AAA                         9                          Adoptive_Father

1                      AAA                         99                        Biological_Father

1                      AAA                         999                      Uncle

2                      BBB                         8                          Adoptive_Mother

2                      BBB                         88                        Adoptive_Father

Appreciate any help and your suggestions.

thanks