Lockwelle,thanks for your response.but i still need further illustrations based on this information provided below.

Really dis is exactly what i need

sn    ExamNo   CSE201   CSE301  CDE401 ....
1     35353         45A           30D       70A
 2    54646          89A           29F       60B

   in dt order.The course titles for the fiellds which are CSE201,   CSE301 , CDE401 will be changing based on d courses  being offerred by the students in the department. Another department own might be

sn    ExamNo   EEE201   TPD301  MEC401 ....
1     35353         45A           30D       70A
 2    54646          89A           29F       60B

the issue is how course name title field will be changing based on the department whose result is to be viewed.Pls illustrate with sample code for me,bcos i am a novice in using crystal report.

Regards