Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
meghna_makadia
Starting Member
3 Posts |
 Posted - 2008-10-13 : 23:02:17
|
| Hi In my ssrs 2000 report dataset returns data like thisorganistion name project nameo1 p1o1 p2o1 p3o2 p4o2 p4like thisnow I want to generate report for each organisation so I use list and groping on organisation. now in my report its likeOrganisation name, p1, p2, p3 projects are included to your organisation. I want my all project names for specific organisation in one textbox seperated by , . Need help to display all the records in single line because if I use the second list and put one text box and field project name it display project name in different lines. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-19 : 05:34:47
|
| if you want project names as comma delimited list, change your query behind to get result in format you want. make use of UDF to produce delimited text as shown belowhttp://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx |
 |
|
|
|
|
|
how to display all the rows of dataset in single l