Print Page | Close Window

Group by field and then get rank

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13613
Printed Date: 20 Apr 2025 at 7:38pm


Topic: Group by field and then get rank
Posted By: GeorgeK
Subject: Group by field and then get rank
Date Posted: 27 Jun 2011 at 11:52pm
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
4         Eng        25
4          Math      57
 
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.


Print Page | Close Window