控件框搜索查询图表该怎么做？要有图中的效果，控件框可以下拉框选择

select to_char(to_date(A.DAY,'yyyymmdd'),'yy-mm-dd') day,a.day d,

sum(actual_move) actual_move,

sum(uptime_loss) uptime_loss,

sum(utilization_loss) utilization_loss,

sum(wph_loss) wph_loss,

max(nvl(wip_eqp,0) + nvl(wip_dummy,0)) wip

from rpt_tool_perf_sx a

where A.c_type= :P42_eqptype

and a.day > to_char(sysdate-32,'yyyymmdd')

group by a.day

order by a.day

FineReport 吕爱慧 发布于 2020-5-22 09:59 （编辑于 2020-5-22 10:20）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

吕爱慧Lv6初级互助
发布于2020-5-22 11:12

select to_char(to_date(A.DAY,'yyyymmdd'),'yy-mm-dd') day,a.day d,
                             sum(actual_move) actual_move,
                             sum(uptime_loss) uptime_loss,
                             sum(utilization_loss) utilization_loss,
                             sum(wph_loss) wph_loss,
                             max(nvl(wip_eqp,0) + nvl(wip_dummy,0)) wip
                        from pc.rpt_tool_perf_sx a
                       where 1=1 and a.day > to_char(sysdate-32,'yyyymmdd')
${if(len(C_TYPE) == 0,"","and a.C_TYPE = '" +C_TYPE+ "' ")}
                group by a.day order by a.day