Ssrs Help Please !

[vizagpower]

I have a sql code which i need to use for ssrs, i have a column with large textual data, so when we wrap the text ,the report looks ugly so my client asked me to dynamically split the large textual data into separate columns


like below

Would you rather have one row for the driver and have multiple comment columns (comment1, comment2, etc.) or do you want it to display as it is w/ one row per comment and just have the other fields in columns A-H filled in?
[center] Would you rather have one row for the driver and have multiple comment columns (comment1, comment2, etc.) or do you want it to display as it is w/ one row per comment and just have the other fields in columns A-H filled in?[/center]

[center][b][u]VENDOR CODE[/u][/b][/center]
[center][b][u]VENDOR NAME[/u][/b][/center]
[center][b][u]STATE[/u][/b][/center]
[center][b][u]FIRSTNAME[/u][/b][/center]
[center][b][u]LASTNAME[/u][/b][/center]
[center][b][u]Status[/u][/b][/center]
[center][b][u]PERSONNEL_TYPE[/u][/b][/center]
[center][b][u]CREDENTIAL NAME[/u][/b][/center]
[b][u]CREDENTIAL COMMENT 1[/u][/b]
[center][b][u]Comment2[/u][/b][/center]
[center][b][u]Comment3[/u][/b][/center]
[center][b][u]Comment 4[/u][/b][/center]
[center][b][u]Comment 5[/u][/b][/center]
[center]5748[/center]
[center]SAFETRANS INC [/center]
[center]DC[/center]
[center]SELELO[/center]
[center]SESHIBE[/center]
[center]Pending Approval[/center]
[center]Driver[/center]
[center]Driving Record[/center]
12/13/2011-failure to provide proof of insurance
12/13/2011-fail to use seat belt
11/20/2011-passing stop sign
08/18/2007-fail to use seat belt




[center]Option 2[/center]
[center][b][u]VENDOR CODE[/u][/b][/center]
[center][b][u]VENDOR NAME[/u][/b][/center]
[center][b][u]STATE[/u][/b][/center]
[center][b][u]FIRSTNAME[/u][/b][/center]
[center][b][u]LASTNAME[/u][/b][/center]
[center][b][u]Status[/u][/b][/center]
[center][b][u]PERSONNEL_TYPE[/u][/b][/center]
[center][b][u]CREDENTIAL NAME[/u][/b][/center]
[b][u]CREDENTIAL COMMENT[/u][/b]
[center]5748[/center]
[center]SAFETRANS INC [/center]
[center]DC[/center]
[center]SELELO[/center]
[center]SESHIBE[/center]
[center]Pending Approval[/center]
[center]Driver[/center]
[center]Driving Record[/center]
12/13/2011-failure to provide proof of insurance
[center]5748[/center]
[center]SAFETRANS INC [/center]
[center]DC[/center]
[center]SELELO[/center]
[center]SESHIBE[/center]
[center]Pending Approval[/center]
[center]Driver[/center]
[center]Driving Record[/center]
12/13/2011-fail to use seat belt
[center]5748[/center]
[center]SAFETRANS INC [/center]
[center]DC[/center]
[center]SELELO[/center]
[center]SESHIBE[/center]
[center]Pending Approval[/center]
[center]Driver[/center]
[center]Driving Record[/center]
11/20/2011-passing stop sign
[center]5748[/center]
[center]SAFETRANS INC [/center]
[center]DC[/center]
[center]SELELO[/center]
[center]SESHIBE[/center]
[center]Pending Approval[/center]
[center]Driver[/center]
[center]Driving Record[/center]
08/18/2007-fail to use seat belt

[AakPakKarivePak]

[pinky123]

[tharun1222]