Dear All,
I am designing a student management system and i am requesting for your help in the design of a report( Report Card). The details of the report are as follows.
Student Subject Marks
1 Eng 50
1 Math 63
1 Sci 54
2 Eng 51
2 Math 73
2 Sci 64
3 Eng 45
3 Math 67
4 Sci 46
So what i want to do is get a report that will display all the subjects and marks per student per page and rank the student by the total marks of the three subject.
For instance using the data above
Student Totalmarks Rank
1 167 3
2 188 1
3 188 1
4 128 4
So each page should show a students Rank , subjects, marks and total marks.
Kindly assist, thanks in advance.