请教
我在做一个查询时,数据集的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 数据集配置错误
貌似报表只能提供一层计算,请大神解惑,谢谢。