crystal report problem

[charvi]

i want to use some fields from three tables and i used relationships and when i want to get displayed in detail section of crystal report it is not displaying but the records are present in recordset
i will writ the code

Dim rs As New ADODB.Recordset
rs.CursorLocati on = adUseClient
Module1.conpass
rs.Open "select EmployeeActivit yMaster.*,Emplo yeeActivityDeta il.*,Employees. employeeid,empl oyees.Name from EmployeeActivit yMaster,Employe eActivityDetail ,Employees where employeeActivit yMaster.id=mast erid" & _
" and EmployeeActivit yMaster.Employe eId=Employees.E mployeeID" & _
" and ProjectId=" & proj & "" & _
" and activityid=" & 1 & "", con, adOpenDynamic, adLockOptimisti c

If rs.EOF = False Then
Report.Database .SetDataSource rs
end if
Screen.MousePoi nter = vbHourglass
CRViewer91.Repo rtSource = Report
CRViewer91.View Report
Screen.MousePoi nter = vbDefault