Click here to Skip to main content
14,875,113 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 "
Updated 26-Apr-15 22:02pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900