请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
田梦语323(uid:97200)
职业资格认证:FCA-FineReport | FCA-FineBI | FCA-业务分析理论
  • 控件名:P_YEARMONTH,选择月份,标题显示如下图所示,我目前是这样写的"1-"+MONTH($P_YEARMONTH)+"月份比"+YEAR($P_YEARMONTH,"YYYY-MM")-1+"年度增长比率"但是显示是不对的
  • 为了实现不同的报表类型,展现不同的显示方式,如图所示在数据集里sql现本期能实现,但是上期、同期实现不了,望大神给与指导!谢谢
  • 【本期sql】select   ${if(RG_REPORT_TYPE=="month",         " a.tongjirq as 实际日期, to_char(to_date(tongjirq,'yyyymmdd'),'dd') as 日期, ",        " a.tongjiyf as 实际日期, a.tongjiyf as 日期, "    )}    sum(a.RENYUANSHU) as 人员数_本期,    0 as 人员数_同期 ${if(RG_REPORT_TYPE=="month", " from REPORT_V_RENLIZY a where a.tongjirq between to_char(to_date('"+P_YEARMONTH+"-01','yyyy-mm-dd'),'yyyymmdd') and to_char(last_day(to_date('"+P_YEARMONTH+"','yyyy-mm')),'yyyymmdd')", "")}${if(RG_REPORT_TYPE=="quarter", " from REPORT_V_RENLIZY_m a where a.tongjiyf BETWEEN '"+P_YEAR+""+P_QUARTER+"' AND TO_CHAR(add_months(to_date('"+P_YEAR+"-"+P_QUARTER+"','yyyy-mm'),3)-1,'YYYYMM')", "")}${if(RG_REPORT_TYPE=="year", " from REPORT_V_RENLIZY_m a where a.tongjiyf like '"+P_YEAR+"%'", "")}${if(len(P_YILIAOJG)==0,"","AND a.YILIAOJGDM = '"+P_YILIAOJG+"'")}${if(len(P_KESHIDM)==0, "", " and a.keshidm in ('" + P_KESHIDM + "')")}${if(RG_REPORT_TYPE=="month", " group by a.tongjirq order by a.tongjirq "," group by a.tongjiyf order by a.tongjiyf ")}【同期sql】select     ${if(RG_REPORT_TYPE=="month",         " a.tongjirq as 实际日期, to_char(to_date(tongjirq,'yyyymmdd'),'dd') as 日期, ",        " a.tongjiyf as 实际日期, a.tongjiyf as 日期, "    )}    0 as 人员数_本期,     sum(a.RENYUANSHU) as 人员数_同期 ${if(RG_REPORT_TYPE=="month", " from REPORT_V_RENLIZY a where a.tongjirq between to_char(add_months(to_date('"+P_YEARMONTH+"-01','yyyy-mm-dd'),-12),'yyyymmdd') and to_char(add_months(last_day(to_date('"+P_YEARMONTH+"','yyyy-mm')),-12),'yyyymmdd')", "")}${if(RG_REPORT_TYPE=="quarter", " from REPORT_V_RENLIZY_m a where a.tongjiyf BETWEEN  to_char(add_months(to_date( '"+P_YEAR+""+P_QUARTER+"','yyyymm'),-12) ,'yyyymm')AND  TO_CHAR(add_months(to_date('"+P_YEAR+"-"+P_QUARTER+"','yyyy-mm'),-12+3)-1,'YYYYMM')", "")}${if(RG_REPORT_TYPE=="year", " from REPORT_V_RENLIZY_m a where a.tongjiyf like '"+(TOINTEGER(P_YEAR)-1)+"%'", "")}${if(RG_REPORT_TYPE=="month", " group by a.tongjirq order by a.tongjirq "," group by a.tongjiyf order by a.tongjiyf ")}
  • 钻取到二级就会报错

5

3

5

10

没有更多
个人成就
内容被浏览2,841
加入社区7年22天
返回顶部