I don’t know if I need pivot or cross tabs. A client wants their report to look like the attachment.
The data is stored in several tables with the User and Course Started stored in joining to another table with Course Number and Course Name and another joining to the Area and Office. The pivot or cross tab is with the Questions. These results are stored in another table that contains the User’s id with the QuestionID, AnswerID, TextAnswer and NumbericAnswer in SQL row column format.
If I did not give enough information just yell.