DataGrid/Data Display Question
Posted on 2004-10-26
I have a form where users can go to fill out a survey. There are 12 questions total. I want to display this data somehow in the following format...
Total Submissions: 5
Excellent Good Average Fair Poor | Average
Question 1 3 1 1 0 0 4.4
Question 2 0 4 0 0 0 3.4
Totals 3 5 1 0 1 4.0
Can I do this with a datagrid? Currently in my database I have a list of submissions (Date, and Responses to Questions 1 - 12). Would it be easier to sum the totals and get the averages in my database? I am using SQL. Or can I do this in my dataset? Basically what is the easiest way to go about doing this. Thanks.