日期:2014-05-20  浏览次数:20932 次

VS2008报表连接Oracle数据库问题,在线等
="select referred,carplate,cartypename,checktime,dldm,lddm,(select storevalue from hkmus_t_syssetting where displayvalue=mil_t_cctvillegal.illtypename) illtypename,illegalid,(select code from hkmus_t_sysuser where name=mil_t_cctvillegal.shooterperson) shooterperson from mil_t_cctvillegal where milcomfirmstatus = 2 " &
IIF(Parameters!ENDCHECKTIME.Value="", "", " And CHECKTIME>= " & Parameters!ENDCHECKTIME.Value) &
IIF(Parameters!TOCHECKTIME.Value="", "", " And CHECKTIME<= " & Parameters!TOCHECKTIME.Value)

上面是SQL语句

出现以下错误 
  本地报表处理期间出错。
  处理报表时出错。
  对数据集“DataSet1”执行查询失败。
ORA-00933:SQL命令未正确结束


那位大哥帮帮忙啊,在线等



------解决方案--------------------
RDLC表达式不支持SQL写法吧