回答：参考帮助文档:https://help.fanruan.com/finereport/doc-view-3421.html?source=1

回答：数据集里面查询语句：${if(len(para_cj) == 0,"","and glcj in ('" +para_cj+ "')")}多选择框属性设置

回答：${if(控件="门诊","SELECT * FROM A WHERE 时间大于开始日期小于结束日期",if(控件="住院","SELECT * FROM B WHERE 时间大于开始日期小于结束日期","SELECT * FROM C WHERE 时间大于开始日期小于结束日期"))}；${IF(统计条件='OUT',"SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN AINNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID  AND C.UNITSTYPEID='0401'INNER JOIN NEWAY_HIS_HNXX_1210.NOP0501B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIALINNER JOIN NEWAY_HIS_HNXX_1210.NOP0501A E ON D.SETTLEID = E.SETTLEIDWHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.SETTLEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.SETTLEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME",IF(统计条件='IN',"SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN AINNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID  AND C.UNITSTYPEID='0401'INNER JOIN NEWAY_HIS_HNXX_1210.NIP0601B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIALINNER JOIN NEWAY_HIS_HNXX_1210.NIP0601A E ON d.CHARGEID = E.CHARGEIDWHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.CHARGEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.CHARGEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME",IF(统计条件='ALL',"SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN AINNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID  AND C.UNITSTYPEID='0401'INNER JOIN NEWAY_HIS_HNXX_1210.NOP0501B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIALINNER JOIN NEWAY_HIS_HNXX_1210.NOP0501A E ON D.SETTLEID = E.SETTLEIDWHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.SETTLEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.SETTLEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAMEUNION ALLSELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN AINNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID  AND C.UNITSTYPEID='0401'INNER JOIN NEWAY_HIS_HNXX_1210.NIP0601B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIALINNER JOIN NEWAY_HIS_HNXX_1210.NIP0601A E ON d.CHARGEID = E.CHARGEIDWHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.CHARGEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.CHARGEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME","")))}

回答：请参考这个链接：http://www.itjcw123.cn/2706.html

回答：按钮控件自定义可以改变按钮的颜色，

回答：参考：https://help.fanruan.com/finereport/doc-view-3051.html