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 |
|
adnanc
Starting Member
3 Posts |
 Posted - 2007-02-20 : 05:19:45
|
Hello All,Apologies if this is the wrong forum section.Some help and advice please regarding a SQL Report.It is for a Feedback form and below is a quick mock up of the DB diagram tblFeedback is populated with a Customers details and the tblResults with the Results of each question they answered.When I'm currently running a report the data is displayed thus:|_Name___|_Email____________|_Comments_______|_Question______________|_Response_|Bob Joe--- bobjoe@email.com --- Great Service ----- Would you come again ---- YesBob Joe--- bobjoe@email.com --- Great Service ----- Would you recommend ---- YesBob Joe--- bobjoe@email.com --- Great Service ----- Would you buy from us ---- YesEach row corresponds to one question and a lot of data is duplicated, it detracts from the important information.What I would prefer is something like the following:|_Name___|_Email____________|_Comments________|_Q1__|_Q2__|_Q3_|_Q4___|_Q5_|_Q6__|_Q7___|Bob Joe--- bobjoe@email.com --- Great Service ------- Yes -- Yes -- No -- Maybe - No -- Yes -- MaybeAfter reading a number of resources, I think a pivot table may help, this will turn the data in tblResults from rows into columns and I should be able to append this via a temporary table.Any brave forummer willing to look into this problem?Many Thanks |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2007-02-20 : 08:31:47
|
| Have a look at this old article, might help you do what you need:[url]http://www.sqlteam.com/item.asp?ItemID=2955[/url]/Andraax |
 |
|
|
|
|
|
SQL Report Help