select DISTINCT EQPGROUP,EQPID,LOCATION,target  from (with temp as(SELECT TO_CHAR(TO_DATE(HISTDATE,'YYYYMMDD'),'YYYYMM') MONTH,
'W'||TO_CHAR(TO_DATE(HISTDATE,'YYYYMMDD')+5,'YYWW') WEEK,
HISTDATE,EQPID,EQPTYPE,LOCATION,
case when (RUN_TIME+BKUP_TIME+IDLE_TIME+LOST_TIME+TEST_TIME+TEST_CW_TIME+SUSPD_TIME+WAIT_MFG_TIME+WAIT_ENG_TIME+HOLD_ENG_TIME+
DOWN_TIME+MON_DOWN_TIME+FAC_TIME+PM_TIME+MON_PM_TIME+MON_R_TIME+CIM_TIME+PROCESS_PM_TIME+OFF_TIME)=0 then 0
else (RUN_TIME+BKUP_TIME+IDLE_TIME+LOST_TIME+TEST_TIME+TEST_CW_TIME+SUSPD_TIME)/
(RUN_TIME+BKUP_TIME+IDLE_TIME+LOST_TIME+TEST_TIME+TEST_CW_TIME+SUSPD_TIME+WAIT_MFG_TIME+WAIT_ENG_TIME+HOLD_ENG_TIME+
DOWN_TIME+MON_DOWN_TIME+FAC_TIME+PM_TIME+MON_PM_TIME+MON_R_TIME+CIM_TIME+PROCESS_PM_TIME+OFF_TIME)
END AS UPTIMES
FROM SDB_TB_EQP_HIST
where histdate >= to_char(sysdate-90,'YYYYMMDD')  
and (eqpid like 'A%' OR EQPID LIKE 'B%')
ORDER BY TO_CHAR(TO_DATE(HISTDATE,'YYYYMMDD'),'YYYYMM'),TO_CHAR(TO_DATE(HISTDATE,'YYYYMMDD'),'YYWW')
,HISTDATE,EQPID,EQPTYPE,LOCATION)

SELECT A.type,A.histdate,B.EQPGROUP,A.eqpid,B.TARGET,A.EQPTYPE, A.LOCATION,A.UPTIME FROM (
select 'DAY' type,histdate,eqpid,EQPTYPE, LOCATION, ROUND(avg(UPTIMES),4) UPTIME from temp WHERE HISTDATE >= TO_CHAR(TRUNC(SYSDATE-7-0.3125),'YYYYMMDD')
group by histdate,eqpid,EQPTYPE, LOCATION) a
left outer join
(SELECT EQPGROUP, EQPID, TARGET FROM SXRPTUSER.M1_TB_EQPMONITOR_MAINTAIN) B
ON A.EQPID = B.EQPID
order by location,EQPGROUP,eqpid)  WHERE 1=1
${if(len(LOCATION) == 0,"","and LOCATION = '" +LOCATION + "'")}
${if(len(EQPID) == 0,"","and EQPID = '" +EQPID + "'")}
${if(len(EQPGROUP) == 0,"","and EQPGROUP = '" +EQPGROUP + "'")}
order by EQPGROUP,EQPID,LOCATION

参数联动

https://help.finereport.com/doc-view-412.html

控件的数据字典之间没有关联性，就是独立查询

下拉框参数联动：

https://help.finereport.com/doc-view-1284.html

无关联不是直接用控件就好了吗 ='${参数}'

直接在sql里加上就可以实现查询，不知道是不是误解你的意思了？

where 1=1 
${if(len(参数1)==0,"","and 字段 = '"+参数1+"' ")}
${if(len(参数2)==0,"","and 字段 = '"+参数2+"' ")}