关于SSRS view report
SSRS preview report 运行正常,可以得到正确的结果,可是deploy之后出现了以下错误:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'ProjectNameDataSet'. (rsErrorExecutingCommand)
ORA-01036: 非法的变量名/编号
附:ProjectNameDataSet 如下:
select distinct project_name
from dbo.project
where (date_entry between (@StartDate) and (@EndDate))
order by project_name
StartDate和EndDate两个参数为DateTime类型
在下实在不知道问题出在哪里?有经验的大侠帮帮忙。