Include Multiple Values In One Row

[redtoad]

I am developing a report which groups Applicant information. There is a new row for each Applicant. The problem I'm having is some of the columns have single values only, and some of the columns have multiple values. I have written sql that generates a record set with a row for each distinct applicant and corresponding row. In other words, there are multiple rows for applicants that have columns with multiple values.

I want to display in Crystal, only one row for each applicant, and put multiple values in columns as neccessary.

Any thoughts would be appreciated.

Thanks.