我在做一个查询时，数据集的sql语句如下：
select * from hrmdepartment
WHERE supdepid =0
${(${fenbu}=1," and 1=1"," and subcompanyid1 = ${fenbu}")}
order by showorder
预览时出错，报错信息为：
正常:SQL: select * from hrmdepartment
WHERE supdepid =0
${${if(1=1," and 1=1"," and subcompanyid1 = 1")}}
order by showorder
警告:错误代码:1301 数据集配置错误
貌似报表只能提供一层计算，请大神解惑，谢谢。
|
