这个写法

${if(参数名,"sql1","sql2")}

========

也可以

关联数据集 https://help.fanruan.com/finereport/doc-view-125.html

========================

参数名，换成你控件名，更新下，你里面有个引号

${if(参数名,"SELECT LT.LOTNO AS 批次号, PT.PARTCODE AS 物料编码, LT.LAUNCHQUANTITY AS 投入量, LT.CURRENTQUANTITY AS 加工量, PD.PROCEDURENAME AS 工序段, OP.OPERATIONNAME AS 工序, US.FULLNAME AS 作业员, LR.ACTUALSTARTDATE AS 开始时间 FROM LOT LT LEFT JOIN LOTROUTING LR ON LT.LOTID = LR.LOTID LEFT JOIN TASK TK ON TK.ROUTINGDETAILID = LR.ROUTINGDETAILID LEFT JOIN WORKUNIT WK ON WK.WORKUNITID = TK.WORKUNITID LEFT JOIN PROCEDUREOPERATION PO ON PO.PROCEDUREOPERATIONID = LR.PROCEDUREOPERATIONID LEFT JOIN PROCEDURE PD ON PD.PROCEDUREID = PO.PROCEDUREID LEFT JOIN OPERATION OP ON OP.OPERATIONID = PO.OPERATIONID LEFT JOIN PART PT ON PT.PARTID = LT.PARTID LEFT JOIN \"USER\" US ON US.USERID = TK.OPERATORID WHERE NOT ( LR.ACTUALSTARTDATE IS NOT NULL AND LR.ACTUALENDDATE IS NULL ) AND LR.ACTUALSTARTDATE >= to_date('"+start_time+"','YYYY-MM-DD HH24:MI:SS') AND LR.ACTUALSTARTDATE <= to_date('"+end_time+"','YYYY-MM-DD HH24:MI:SS') ORDER BY LT.LOTNO, LR.ACTUALSTARTDATE","SELECT PD.PROCEDURENAME AS 工序段, OP.OPERATIONNAME AS 工序, COUNT( LT.LAUNCHQUANTITY ) AS 总批次, SUM( LT.LAUNCHQUANTITY ) AS 总数量 FROM LOT LT LEFT JOIN LOTROUTING LR ON LT.LOTID = LR.LOTID LEFT JOIN PROCEDUREOPERATION PO ON PO.PROCEDUREOPERATIONID = LR.PROCEDUREOPERATIONID LEFT JOIN PROCEDURE PD ON PD.PROCEDUREID = PO.PROCEDUREID LEFT JOIN OPERATION OP ON OP.OPERATIONID = PO.OPERATIONID WHERE NOT ( LR.ACTUALSTARTDATE IS NOT NULL AND LR.ACTUALENDDATE IS NULL ) AND LR.ACTUALSTARTDATE >= to_date('"+start_time+"','YYYY-MM-DD HH24:MI:SS') AND LR.ACTUALSTARTDATE <= to_date('"+end_time+"','YYYY-MM-DD HH24:MI:SS') GROUP BY PD.PROCEDURENAME, OP.OPERATIONNAME")}

写在sql里，查到哪个参数执行哪一段。

在两个数据集分别价格条件呗

比如参数A  执行数据集1

${if(参数名='A',"1=1","1=2")}

比如参数B  执行数据集2

${if(参数名='B',"1=1","1=2")}

 根据参数隐藏sheet页

JS隐藏sheet页 https://help.fanruan.com/finereport/doc-view-1740.html

别闹了。你数据量大，还有关联数据集？？？你到底是想让它出来。不是不想让它出来。采用etl同步在一张表，把结构设计成一样的。没有的列为空就行，增加一列数据来源类型。。比如ds1  与ds2两个。最后直接查询这一张的数据来源类型就行了。而不是你这样分开写。。。再判断

with a as (select 1 as column1,2 as column2 from dual),

b as (select 1 as column1,2 as column2,3 as column3 from dual),

c as (select 1 as column1,2 as column2,3 as column3,4 as column4 from dual) 

select

a.column1,a.column2,b.column3

${if(detail='True',"",",sum(c.column4)")}

from a

left join b on a.column1=b.column1 and a.column2=b.column2

${if(detail='True',"","left join c on a.column1=c.column1 and a.column2=c.column2")}

where 1=1

${if(detail='True',"","group by a.column1,a.column2,b.column3")}

${if(detail='True',"order by a.column1,a.column2,b.column3","")}

試一下動態取就好了，因為你兩個數據集where條件都是一樣的這樣寫可能簡單點，速度也不會有影響