I need some advice in my situation. I have db. table with next values (fake values):
CustmerID Question Answer
0001 MyQuestion1 Answ1
0001 MyQuestion2 Answ1
0002 MyQuestion1 Answ1
0002 MyQuestion2 Answ2
0002 MyQuestion2 Answ3
0003 MyQuestion1 Answ1
0003 MyQuestion2 Answ2
0003 MyQuestion3 Answ3
I need put them into result "table".
I want to use matrix because I don't know how many questions(columns in my result) are in the db. table.
Here result I want to get:
Question1 Question2 QuestionN
Customer1 Answer1, Answer2 Answer1, Answer2, Answer3 Answer1, AnswerN
Customer2 Answer1 Answer2, Answer3 AnswerN-1, AnswerN
CustomerN etc. etc. etc.
How I can Join fields with comma using standard reporting services features? Or I need write custom VB code? Examples?
I know that Data field is good for agregate functions, like Sum, Avg, etc. But I need another logic. Also I couldn't join
View Complete Post