Slow in loading crystal report in vb6

See more:

reporting

Hello guys, Im having a hard time in loading my crystal report using vb6. Can you help me with my query?

Here is my query.

ssql = "SELECT Temp_Portal.SectionCode, Temp_Portal.nr_workcode, Temp_Portal.Order_Number, Temp_Portal.Item_Number, " & _
"tbl_WC_FWBS.FWBS_Code, tbl_WC_FWBS.FWBS_Application, Temp_Portal.Project_Total, tbl_Department.dept_name, " & _
"Temp_Portal.Project, Temp_Portal.Billing_Month, Temp_Portal.Billing_Year " & _
"FROM MTS_Portal.dbo.tbl_WC_FWBS tbl_WC_FWBS INNER JOIN (MTS_Portal.dbo.tbl_Department tbl_Department INNER JOIN MTS_Portal.dbo.Temp_Portal Temp_Portal ON tbl_Department.department_id=Temp_Portal.Dept_ID) ON tbl_WC_FWBS.Work_Code=Temp_Portal.Work_Code " & _
"WHERE Temp_Portal.Project_Code='" & gProjectCode & "' AND Temp_Portal.IsBillable='1' " & _
"ORDER BY tbl_Department.dept_name, Temp_Portal.Project, Temp_Portal.nr_workcode "