Doubt in Crystal Reports for VS.NET

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embarrassing question about lookup. 4
lookup without repeats 3
Range selection 2
Comparing Multiple fields 3
Namespace question 10
vb help 6
Removing unnecessary rows through macro 6
I need a formula 1

Top