Displaying selected records in data reports

[c_hillary2000]

Hi all
I am using data reports with out data environment.Here i am displaying the report using a table. But i am not able to display the selected records.
For e.g. A report displays Student id, Name and result.
But i want to display the results of only the passed students.can anyone please tell me How i do this?


I have used the following code:

Private Sub DataReport_Initialize()
'Procedure to connect database
connection
 
strSQL = "SELECT * from tblstudent"
Set rs = New ADODB.Recordset
rs.Open strSQL, cn, adOpenDynamic, adLockOptimistic
Set DataReport1.DataSource = rs
End Sub