crystal reports?

[tycoonux]

Dear experts,

kindly help me on this..badly needed...thanks in advance
using here...vb.net2005,mysql,crystalrep

tblTrainee

TrNo TrFname TrLname
1 Piolo Pascual
2 John Cruz
3 Aga Muhlach
4 Luis Manzano


tblClass

TrNo SubjCode FinalGrade
1 CP1 90
1 CP2 88
1 CP3 80
2 CP1 77
2 CP2 80
2 CP3 60
3 CP1 60
3 CP2 70
3 CP3 80
4 CP1 100
4 CP2 70
4 CP3 65


Crystal Report - Required Format/Layout


No Lastname Firstname Subject1 Subject2 Subject3 ...
FinalGrade FinalGrade FinalGrade FinalGrade

example:

1 Pascual Piolo CP1 CP2 CP3
80 88 80
2 Cruz John CP1 CP2 CP3
77 80 60

 

[Hack]

What is the question?

 

[tycoonux]

thanks for ur concern...


how can i display it using the required format in Crystal Reports...

Trno    TrLname   TrFname    SubjCode1  SubjCode2   SubjCodeN
                                        Finalgrade  FinalGrade    finalGrade

additional...

what is the correct SQL statement for this...

my agony is really on how to display it properly in the report....