Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Group by field and then get rank Post Reply Post New Topic
Author Message
GeorgeK
Newbie
Newbie


Joined: 31 Oct 2010
Online Status: Offline
Posts: 8
Quote GeorgeK Replybullet Topic: Group by field and then get rank
    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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.