Doubt in Crystal Reports for VS.NET

[boomesh]

Hai all

Can any one help of the following issue with Crystal reports for VS.NET

i am using a stored proc to create a table, which forms the source for my report.
In the stored proc, i am performing a string concatenation of all the names and presenting in one column. The concatenated string has only unique names.

When i print the report in crystal report for VS.NET i need some thing like this

1 2 3
----------------------------------------------------------------------------------------------
1 name1, name2, name3 0.0090 1.
name4, name5, name6, 0.0090 1.
name4, name5, name6, 0.0090 1.
name7, name8, name9, 0.0090 1.
name10, name11, name12, 0.0090 1.
name13, name14, name15, 0.0090 1.
name16, name17, name18 0.0090 1.
----------------------------------------------------------------------------------------------
5.2322 5.
----------------------------------------------------------------------------------------------

but as all the names are taken from a single cell, i am getting like this.

1 2 3
----------------------------------------------------------------------------------------------
1 name1, name2, name3 0.0090 1.
name4, name5, name6,
name4, name5, name6,
name7, name8, name9,
name10, name11, name12,
name13, name14, name15,
name16, name17, name18
0.0090 1.
0.0090 1.
0.0090 1.
0.0090 1.
0.0090 1.
----------------------------------------------------------------------------------------------
5.2322 5.
----------------------------------------------------------------------------------------------

The spaces between the first row and the remaining is the issue

can any one help me in doing it in CR

thanks
V.Boomess

[V.Boomessh]

Hi Roy

Thanks for the reply. Regarding column 2, the way in which i gave you in the earlier mail was just a sample. Actually the COLUMN 2 comprises the names like the following

name1, name2 , name3 son of name 4,
name5, name6, name7 son of name 8
name9 wife of name 10 ..

There can be thousands of name like this. Also i cannot split the column values as everything was combined using some logic in the stored proc. Is there any way out

Thanks
V.Boomessh

[V.Boomessh]

Hi Roy

Thanks for the reply. Regarding column 2, the way in which i gave you in the earlier mail was just a sample. Actually the COLUMN 2 comprises the names like the following

name1, name2 , name3 son of name 4,
name5, name6, name7 son of name 8
name9 wife of name 10 ..

There can be thousands of name like this. Also i cannot split the column values as everything was combined using some logic in the stored proc. Is there any way out

Thanks
V.Boomessh