Split character Reporting Service (Character "ENTER")

Question

i had one row from database when i view this data on reporting service i get view:

baris 1 baris 2

i want to change view on reporting service to be

baris 1
baris 2

anyone can help please?

you can add [RowNumber()](http://msdn.microsoft.com/en-us/library/ms159225%28v=sql.90%29.aspx) in your report with spit the data. — Hiten004, Mar 08 '13 at 03:51
here is the link for the split the string. http://stackoverflow.com/questions/10914576/tsql-split-string — Hiten004, Mar 08 '13 at 04:36

score 0 · Answer 1 · answered Mar 11 '13 at 01:35

I would use a combination of the Split function with the constant: Constants.vbCrLf. In your scenario the Split might be tricky - there's no obvious delimiter to split on.

This example might get you started:

= "1. " + Split ( Fields!my_column.Value , " " )(0) + " " + Split ( Fields!my_column.Value , " " )(1) + Constants.vbCrLf + "2. " + Split ( Fields!my_column.Value , " " )(2) + " " + Split ( Fields!my_column.Value , " " )(3)

Split character Reporting Service (Character "ENTER")

1 Answers1