水晶報表調用過程中提示﹕Cannot open SQL server
程序通過水晶報表調用存儲過程。
程序沒有問題
存儲過程沒有問題
但是在調用水晶報表時候提示如下錯誤﹕
執行階段錯誤 '20599'
Cannot open SQL server
誰能幫我看看?
附﹕存儲過程
CREATE PROCEDURE ShiftNo_Query
@Condition as char(200)
AS
SET QUOTED_IDENTIFIER OFF
DECLARE @strSql char(500)
SET @strSql='SELECT E.factorycode,O.cname as
F.name,E.deptcode,D.cname as Dname,T.empcode,E.empName,
convert(char(10),T.day,111) as day,T.shift FROM WK_Transaction T
LEFT JOIN emp_empinfo E ON T.empcode=E.empcode
LEFT JOIN Factory O ON E.factorycode=O.factorycode
LEFT JOIN Department D ON E.deptcode=D.deptcode
WHERE Isnull(E.EndDate,1)=1 '
exec(@strSql+@Condition)
SET QUOTED_IDENTIFIER ON