Hi every one,

I am new to vb and I need some help.
I am using vb6. I am generating a report in the following format by using data report:

Subject: Maths
Teacher: A
Student: A Pass
Student : B Pass
Student: C Pass

Subject: English
Teacher: B
Student: A Pass
Student : B Pass
Student: C Pass

Subject: Maths
Teacher: C
Student: A Pass
Student : B Pass
Student: C Pass

While I actually need to generate report in the following format:


Teacher: A

Student Name Maths English Science
Student: A Pass Pass Fail
Student : B Pass Fail Pass
Student: C Pass Pass Pass

Teacher: B

Student Name Maths English Science
Student: D Pass Pass Fail
Student: E Pass Fail Pass
Student:F Pass Pass Pass


Teacher: C

Student Name Maths English Science
Student: G Pass Pass Fail
Student : H Pass Fail Pass
Student: I Pass Pass Pass


I guess that to generate report inthis format I need to creat record set and then generate report but I have no Idea how to do that.
Please give some example code.

The data I am getting after executing storeprocedure is like that:

Student A Teacher A Maths Pass
Student A Teacher A English Pass
Student A Teacher A Science Pass
Student B Teacher A Maths Pass
Student B Teacher A English Pass
Student B Teacher A Science Pass
Student C Teacher A Maths Pass
Student C Teacher A English Pass
Student C Teacher A Science Pass
Student D Teacher B Maths Pass
Student D Teacher B English Pass
Student D Teacher B Science Pass
Student E Teacher B Maths Pass
Student E Teacher B English Pass
Student E Teacher B Science Pass
Student F Teacher B Maths Pass
Student F Teacher B English Pass
Student F Teacher B Science Pass
Student G Teacher C Maths Pass
Student G Teacher C English Pass
Student G Teacher C Science Pass
Student H Teacher C Maths Pass
Student H Teacher C English Pass
Student H Teacher C Science Pass
Student I Teacher C Maths Pass
Student I Teacher C English Pass
Student I Teacher C Science Pass

I will really appereciate if some one could help me.

Cheers