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 c

I get something like this in my dataset from an oracle package which i dont have access to change....

I need

2345 Payoff,loan s

2345 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