I want to create a cross tab report.
I tried it my self but can get the desired result
I want my report to have the follwing format
Student Id = 100099
name = Ali Raza
secion = SB09GRA
session = 99-00
                         first term 2nd term 3rd term grand toal
english total marks 100 100 100 300
        obtained marks 98 90 90 278
math total marks 100 100 100 300
        obtained marks 81 84 90 255
physics
chymistry
.
.
..
grand toal 800 850 850
                           720 720 720
                            A B C
                            % % %


now the Information of the marks that a student obtained in a term in a subject are in the table "exam_result".
total marks of the subject for a term are in the table "termk_sub".

Tables have following feilds
Exam_result
student_id
term_id
subject_Id
marks_obt
grade
dexam(date of exam) (as string there is a reason making it string)
year (data like 98-99)

term_sub
term_Id,
subject_Id
total marks

term
term_id
term
wing_id

actually it is an application developed for school so a school has wings then one wing can many classes like Junior wing has 1-4 class/ grades(I am in Pakistan and not familiar with ur system) then each class is devided in many section atleast 5 sections
there can be any no of terms as defined by the policy of school (term in easy words like in semester system we have mid term and final term )
now the terms can have differant subjects

the feilds rows 2,3,4 from bottom wil have data from the table cexam_result I can't make it total from the report (if the school changes poilcy about the total marks of a subject in term then it will cause problem for me)

Now It can be acheived
and this report should take input of
studentId
year
and section of the student.


If u can't explain u my problem then give me a link of a tutorial where cross tab report creat is expalined in detail so that I can get help from there.
Plz help me coz I've submit this project in this week under any circumstances...................:(:(:(

I for got to mention
that I am oracle 8.1.6 and crystal reports 8.5 and VB 6.0 (not dot net )and wing 2k
I posted here by mistake ...........
I appologise and plz answer this question