Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Please HELP Post Reply Post New Topic
Author Message
tycoonux
Newbie
Newbie


Joined: 06 Nov 2009
Location: Philippines
Online Status: Offline
Posts: 1
Quote tycoonux Replybullet Topic: Please HELP
    Posted: 06 Nov 2009 at 5:50am
tblTrainee
 
TrNo   TrFname   TLname
1        John          Doe
2        Jane          Doe
 
 
tblClass
 
TrNo   SubjCode   FinalGrade
1        Math1        90
1        English1    80
2        Math1        95
2        English1    90
 
 
 
here's my required output in crystal reports
 
 
Trno  TrLname   TrFname   SubjCode1   SubjCode2
                                           Final grade  FinalGrade
 
 1     Doe           John         Math1            English1
                                          90                   80
 
2     Doe            Jane           Math1          English1
                                           95                  90
 
 
 
   
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 06 Nov 2009 at 6:43am

you would need to use a formula to place them all on one line. shared variables, set them for each class.  If the classes are dynamic, and not from a list, you might want to run dual shared arrays, one with the name of the course and one with the grade, might be a challenge to display.

regardless, you are going to need a formula and display the results in a group footer.  If you are going to do aggregate totals on the grades, you will need more variables as they will be needed to keep track of the values.
 
HTH
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.047 seconds.