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写法吧