添加参数数据集
本帖最后由 Lenka.Guo 于 2016-8-2 15:22 编辑RDL报表 添加有参数局数据的时候经常报错 例子上的SQL语句也报错
以下是具体查询:
FROM Producers INNER JOIN
(Movie INNER JOIN MovieProducers ON Movie.MovieID=MovieProducers.MovieID)ON
Producers.ProductionID=MovieProducers.ProductionID
WHERE(MovieProducers.ProductionID IN(?))OR (-1 IN(?))
ORDER BY MovieProducers.ProductionID,Movie.YearReleased
能看下有哪里出错么
您使用的是SQL server数据库吗?
建议改成:
Select *
FROM Producers INNER JOIN
(Movie INNER JOIN MovieProducers ON Movie.MovieID=MovieProducers.MovieID)ON
Producers.ProductionID=MovieProducers.ProductionID
WHERE(MovieProducers.ProductionID IN(?))OR (-1 IN(?))
ORDER BY MovieProducers.ProductionID,Movie.YearReleased 好了 多谢。 ensure_sl 发表于 2016-8-3 11:12
好了 多谢。
:hjyzw:
页:
[1]