How to Split comma " , " seperated values in a cell to adjacent different column with same column header in SSRS

Question

0.00/5 (No votes)

See more:

How could I Split comma " , " seperated values in a cell to get value into adjacent different column with same column header in SSRS
I got a query table in SSRS report as follows

HTML

ProjectNo.    |  ProjectName      |      Client             |        Programmers |  
01            |    ave            |       rowan, Zica       |        A, B, C     |

Now I want to display this in SSRS as Follows -

HTML

ProjectNo.  |  ProjectName  |   Client             | Programmers               |                            
 01         |    ave        |   rowan     |  Zica  | A           |  B   |  C   |

Any suggestion How could i achieve this only using SSRS ,and not modifying the query...

Posted 24-Apr-14 0:02am

waleed ahmed wadkar

Updated 24-Apr-14 0:05am

v4

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

waleed ahmed wadkar · Accepted Answer · 2014-04-24T04:00:00

Solution 1

http://social.msdn.microsoft.com/Forums/en-US/92069abb-13f1-45bc-b5cc-2c7dfdacc365/need-help-on-ssrs-split-function?forum=sqlreportingservices

Posted 24-Apr-14 4:00am

waleed ahmed wadkar

How to Split comma " , " seperated values in a cell to adjacent different column with same column header in SSRS

1 solution

Solution 1

Add your solution here

Preview 0

How to Split comma " , " seperated values in a cell to adjacent different column with same column header in SSRS

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us