Friday, February 17, 2012

dynamic column headings?

Is it possible for Report Services 2000 to accomplish the following. Are there any examples available that i can take a look?

How can I turn rows in a table into column headings in a report. By the way, the user can chose one questions to see the answers for all the Test Takers.

The questions and answers are rows in two seperate tables.

For example, a certain test may have N questions and N answers. I would like to make the questions the column headings and the answers the rows. Into something like this.

Test Taker Questions 1 Questions2 Questions3 QuestionsN+1

Mike Jay Answer1 Answer2 Answer3 AnswerN+1

Jon Doe Answer1 Answer2 Answer3 AnswerN+1

etc....

Can anyone suggest a solution or documentation?

Thank you,

yadgor2000

Try using a matrix. You can easily do this in VS.Net.

No comments:

Post a Comment