Traspose a table next to another in a SSRS report

Vote count:

0

My current project involves a ssrs that shows the customer data(coming from 3 table joined, each record represents a customer). Each of these customers has compiled a survey and all the answers are stored in a table that has the following fields(ID,SurveyID,CustomerID,QuestionID,Answer).

I have to take all the rows related to a customer from the table SurveyAnswers and traspose them next to the Customer data to show all the answers given to the survey as columns.

The result should look like this:

CustomerID | Data1 | Data2 | ... | QuestionID1 | QuestionID2 | ...

000---------- | xxx---- | xxx---- | .. | Answer1----- | Answer2

Sure I can PIVOT the Answers table in SQL, but is there a way to achieve it in SSRS?

asked 36 secs ago

DkSw

31

Traspose a table next to another in a SSRS report