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 |
|
rchalla
Starting Member
3 Posts |
 Posted - 2011-11-09 : 08:23:19
|
| I have a requirement where i need to concatenate values of multiple rows into single comma seperated field based on a common field in the same data set...Not sure if i made it clear ... 2345 payoff s 2345 loan s 2345 Mortgage c 2345 Title cI get something like this in my dataset from an oracle package which i dont have access to change....I need 2345 Payoff,loan s2345 Mortgage,Title c in my report in a single row ... i could do it in storeprocedure but i dont have access to modify, all i can do is get the dataset as it is so i have to do this in RDL ...Can we do this .. any help would be great!!Thanks,Raj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-09 : 09:04:56
|
| its not striaghtforward to do this within dataset. the best way to do this is by using custom code if you want to do it in reports. else you may have to do it in sql itself.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
rchalla
Starting Member
3 Posts |
Posted - 2011-11-09 : 09:45:09
|
| I have just read only access to oracle package which i am using in the report. so custom code would be fine if it works,But i havent worked on custom code before..let me know if you have any examples anywhere how to do this! |
|
|
|
|
|
|
Can we achieve this in Report RDL?