Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Compare Groups Post Reply Post New Topic
Author Message
LittleRascal
Newbie
Newbie
Avatar

Joined: 11 Sep 2010
Location: Bahamas
Online Status: Offline
Posts: 5
Quote LittleRascal Replybullet Topic: Compare Groups
     Posted: 10 Oct 2010 at 3:40pm
I have 2 groups 
Teacher (GF1)
Gender (GF2)
I need to display highest group name and average grades for each teacher by Gender.  For example:
 
Student  Gender    Test1   Test2  Test3
A              M            90         50      60
B              M             80         90      70
C              F             60         80     80 
D              F             100       70     80
 
Expected Result
Test 1  M 85
Test 2  F 75
Test 3  F 80
 
Any help would be appreciated.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 11 Oct 2010 at 3:34am

I don't think that you can.  The grouping by teacher will trump the gender, so you all always get a sum of just that teacher.  Reversing the groups would make more sense (a teacher can only be 1 gender)  So GF1 should be Gender and GF2 teacher, then you should be able to get the results that you want.

 
HTH
IP IP Logged
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