• 
  日期函数问题

  控件名:P_YEARMONTH，选择月份，标题显示如下图所示，我目前是这样写的"1-"+MONTH($P_YEARMONTH)+"月份比"+YEAR($P_YEARMONTH,"YYYY-MM")-1+"年度增长比率"但是显示是不对的

  274个浏览 3个回答 FineReport 2020年10月20日发布
• 
  求上期同期的问题

  为了实现不同的报表类型，展现不同的显示方式，如图所示在数据集里sql现本期能实现，但是上期、同期实现不了，望大神给与指导！谢谢

  636个浏览 4个回答 FineReport 2019年04月26日发布
• 
  如何实现本期同期的趋势分析

  【本期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 ")}

  357个浏览 1个回答 FineReport 2020年03月31日发布
• 
  日期控件联动，选择不同的报表类别，显示相应的日期控件

  471个浏览 2个回答 FineReport 2019年04月23日发布
• 
  钻取到二级就会报错

  钻取到二级就会报错

  674个浏览 4个回答 FineReport 2019年04月22日发布

5

3

5

10