displaying transactional data horizontally

Posted by Orestes under Sql Server on 9/4/2009 | Views : 1046 | Status : [Member] | Replies : 2
am using sql server (msde) 2000 the report is already in excel manually
updated
need help with a sql statement. I have a transactional data but I want to
represent it horizontally AND Pivoting doesn't work.
here is the example:

student(table) studentid, name .....
class(table) classid, semesterid subjectid grade(6th,7th,8th ext).....
subjects(table) subjectid subjectdesc credits
enrollment (table) classid studentid finalgrade(A,B,C...ext)

what I need is to generate the transcript(which is in excel) in the following format

filtered by student.....

6th grade 7th grade 8th grade
I II crd I II crd I II crd
grammar A B .5 A B .5 C B .5
reading C B .5 C B .5 A B .5
EXT....
(I = First semester and II = Second Semester)
pivoting doesn't work because it sums the grades instead of displaying the
actual grade......

sample data and database diagram attached

thaks




Responses

Posted by: Vuyiswamb on: 9/28/2009 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Did you get a Solution to your Problem?

Thank you for Posting at Dotnetfunda


Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Orestes, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Orestes on: 9/28/2009 [Member] Starter

Up
0
Down
no still need an answer!!!!!!

Orestes, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response