Data Report Problem

[vsriharsha]

Hi Everyone,

Im also facing a problem, Im sure most of the amatures are facing with Data Reports.
I have a
Table T1 with RollNumber,TestDate and Marks Obtained.
Table T2 with RollNumber and Name.
Table T3 with TestNumber, TestDate and TotalMarks.

Now I want to retrieve the following and display as a report in DataReports of VB.

"All the names, TestNumber, TestDate, TotalMarks and Marks obtained of the STudents who have taken a Test on a particular date (eg: 03/15/2004)"

Test Number      Test Date      TotalMarks     Name    MarksSecured

1               03/15/2004    150              Mr. A       80
                                               Mr. B       75
                                               Mr. C       125
                                               Mr. D       120

Now the problem is: If i Use a sql query to create a new table with the above fields, Im getting the first 3 cols repeated and as a result, the same is reflected in the Report which I dont want.
PLEASE ADVICE SOON.

Warm Regards,
Sriharsha.[CODE]