field is a list of comma separated values

HSMorales

I have a dataset created from a stored procedure.
The procedure returns 3 fields.
Life_Ins, Empl_name, Bens.

Life_Ins contains a list of comma seperated values such as "Ins1,Ins2,Ins3".
Bens contains a list of comma seperated values such as "Spouse,Son,Daughter,Aunt,Uncle"

How can I get the values in Life_Ins and Bens to be stacked in list form in the detail section of my report??

Thanks for all your help.

johnw

Take a look at the following example.

The way I did this was I created a Scripted Data Set with a single parameter. On the open event, I split the value of that parameter into an array. For the fetch, I just get the element in the array and compare the size of the array to the current count. In my report design, I have a table that has columns with comma separated values. I pass the comma separated values in as parameter values into a sub table bound to the scripted data set. This will give me a list. The list can be variable, and the data set can be re-used (which is what I did in both columns.