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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2009-01-19 : 06:25:15
|
| I would like to concatenate dataset field values like:=Join(Fields!Total.value,","). I have done similar for parameter selections:=Join(Parameters!Year.Value, ",") Is it possible to do this for returned field values? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-19 : 09:23:10
|
| returned field values from where? |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-01-19 : 09:42:04
|
| this dataset values which are displayed in the values cells in a matrix, e.g. Fields!x.value.I have found work-around but I would still be interested if it is possible to join these values the way parameters can be concatenated. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-19 : 09:51:59
|
| you want all values of dataset to come as comma seperated in single row? |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-01-19 : 10:24:19
|
| To concatenate them any where really - it's the method which I'm not sure of. For instance put them into a label or into a calculated field. I know how to do it for parameters selected in drop down list,(=Join(Parameters!Year.Value, ",") );just trying to do same for dataset values. |
|
|
|
|
|
|
concatenate field values