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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Matrix report

Author  Topic 

imughal
Posting Yak Master

192 Posts

Posted - 2005-03-24 : 23:11:34
hi,

i m working on student evaluation form. student has many subject and each subject is thought by teacher. evaluation form is simple header part include student and teacher general information and detail containts the question. now i need to prepare evaluation report in matrix form. like this

teacher name subject Question 1 question 2... question8
TA S1 1 2 3

Each question has three option 1.good 2.fair 3. excellent
and should be 1.

I have to calculate the no of 1,2 and 3 ans on the basis on teacher and subject. so how do i prepare this report. The table structure are

Eval_res_master
eval_res_detail
std_suject
std_faculty

any suggestion will be appreciated.

Thanks in advance.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-25 : 06:13:17
my guess is you'll need this:
http://www.sqlteam.com/item.asp?ItemID=2955

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -