求助,在access中通过的脚本,为何在sql 报表服务器中报错呢?
SELECT ui.userid AS 员工ID, ui.Name AS 员工姓名, cio.CHECKTIME AS 打卡时间, IIf(Weekday(cio.CHECKTIME)=2,"星期一",IIf(Weekday(cio.CHECKTIME)=3,"星期二",IIf(Weekday(cio.CHECKTIME)=4,"星期三",IIf(Weekday(cio.CHECKTIME)=5,"星期四",IIf(Weekday(cio.CHECKTIME)=6,"星期五",IIf(Weekday(cio.CHECKTIME)=7,"星期六",IIf(Weekday(cio.CHECKTIME)=1,"星期日","日期错误"))))))) AS 星期
FROM CHECKINOUT AS cio, USERINFO AS ui
WHERE (((cio.USERID)=[ui].[USERID]) AND ((Format([cio].[CHECKTIME],"yyyy-mm-dd"))=Format(Date(),"yyyy-mm-dd")))
ORDER BY ui.Name, cio.CHECKTIME;
上面代码在access库中执行正常。
放到报表服务其中报错如下:
ERROR [07002] [Microsoft][ODBC Microsoft Access 驱动程序] 参数不足,期待是 9。
请问如何解,谢谢!