• 
  控件的可用设置

  两个单元格控件,当控件1的值="首开"时,控件2可用,当控件1的值="加推"时,控件2不可用,这个应该用编辑后事件来做,但我不会写,求助,帮忙写一下.

  903个浏览 1个回答 FineReport 2019年03月06日发布
• 
  移动端填报预览

  我的填报模板是由一张预览的模板超链接传参跳转的,在路径后加上了&op=write但是跳转后可以修改填写,修改后没有提交的按钮"√".这是什么情况?

  852个浏览 1个回答 FineReport 2019年03月06日发布
• 
  帮忙看一下标签自定义的代码

  function(){var Widgeta=_g().parameterEl.getWidgetByName("org");var org = Widgeta.getValue();var Widgetb=_g().parameterEl.getWidgetByName("V_MONTH");var V_MONTH = Widgetb.getValue();var a = this.category; var sql="selectVBUNAME,VMONTH,round(SUM(NRECLEFT)/(select SUM(NRECLEFT) from DM_REC_MONTH where DM_REC_MONTH.VMONTH = a.VMONTH),2)*100||'%' AS A1 from DM_REC_MONTH a where VMONTH ='"+V_MONTH+"' AND VBUNAME = '"+a+"' AND '"+org+"'='00'GROUP BYVBUNAME,VMONTH"+" UNION ALL "+"selectUNITSHORTNAME,VMONTH,round(SUM(NRECLEFT)/(select SUM(NRECLEFT) from DM_REC_MONTH where DM_REC_MONTH.VMONTH = a.VMONTH AND DM_REC_MONTH.VBUCODE = '"+org+"'),2)*100||'%' AS A1 from DM_REC_MONTH aLEFT JOIN DIM_ORGON DIM_ORG.UNITCODE = a.VORGCODEwhere VMONTH ='"+V_MONTH+"' AND UNITSHORTNAME = '"+a+"' AND '"+org+"'IN ('05','04','03','02','01')"+" AND VBUCODE ='"+org+"'"+"GROUP BYUNITSHORTNAME,VMONTH"+" UNION ALL "+"selectUNITSHORTNAME,VMONTH,round(SUM(NRECLEFT)/(select SUM(NRECLEFT) from DM_REC_MONTH where DM_REC_MONTH.VMONTH = a.VMONTH AND DM_REC_MONTH.VORGCODE = '"+org+"'),2)*100||'%' AS A1 from DM_REC_MONTH aLEFT JOIN DIM_ORGON DIM_ORG.UNITCODE = a.VORGCODEwhere VMONTH ='"+V_MONTH+"' AND UNITSHORTNAME = '"+a+"' AND '"+org+"' NOT IN ('05','04','03','02','01')"+" AND VORGCODE ='"+org+"'"+"GROUP BYUNITSHORTNAME,VMONTH";var res=FR.remoteEvaluate('sql("test","'+sql+'",3,1)');returnres+this.category+"|"+this.seriesName+":"+Math.round(this.value);}我不太懂var 的内容和select的where条件

  508个浏览 1个回答 其他问题 2019年03月04日发布
• 
  更改饼图的图例显示内容

  能将"A"换成"红灯","B"换成"黄灯","C"换成"绿灯"吗?我搞错了,没有问题了

  1477个浏览 2个回答 FineReport 2019年03月01日发布
• 
  EXCEL导入

  当我导出的EXCEL有数据时,,修改后导入EXCEL 为什么已有的数据会消失?

  1224个浏览 1个回答 FineReport 2019年03月01日发布
• 
  SQL根据经纬度计算距离

  表1:dc_tproject_d, 经度:lo_num, 纬度:la_num表2:dc_cproject_d, 经度:lo_num, 纬度:la_num计算表1项目和表2项目的距离

  1007个浏览 2个回答 SQL 2019年03月01日发布
• 
  怎样将系列名或固定的字显示于X轴两端?

  把"两会"显示在左侧,把"实际"显示在右侧?

  534个浏览 2个回答 FineReport 2019年03月01日发布
• 
  将轴标签显示在条形图的柱子上

  现在显示在了柱子后面看不见,怎么将标签显示在柱子之上?

  628个浏览 1个回答 FineReport 2019年03月01日发布
• 
  去化周期的标准差sql

  这个计算要处理时间,不太会去化周期:当前月的存量/前六个月的平均成交量标准差:以过去前36个月的去化周期做计算下面是我处理其他数据的sqlselect A1.region_id,A1.city_id,(A1.deal_qty-A4.deal_qty)/A4.deal_qty cjltb,--成交量同比(A1.deal_qty-A3.deal_qty)/A3.deal_qty cjlhb,--成交量环比(A1.aveprice_amt-A4.aveprice_amt)/A4.aveprice_amt jjtb,--均价同比(A1.aveprice_amt-A3.aveprice_amt)/A3.aveprice_amt jjhb,--均价环比(A1.act_deal-A4.act_deal)/A4.act_deal gqbtb,--供求比同比(A1.act_deal-A3.act_deal)/A3.act_deal gqbhb,--供求比环比(A1.stock_qty/A2.deal_qty_avg-A4.stock_qty/A6.deal_qty_avg)/A4.stock_qty/A6.deal_qty_avg qhzqtb,--去化周期同比(A1.stock_qty/A2.deal_qty_avg-A3.stock_qty/A5.deal_qty_avg)/A3.stock_qty/A5.deal_qty_avg qhzqhb,--去化周期环比(A1.sell_rate_pct-A4.sell_rate_pct)/A4.sell_rate_pct qhltb,--去化率同比(A1.sell_rate_pct-A3.sell_rate_pct)/A3.sell_rate_pct qhlhb,--去化率环比A1.deal_qty,--上月成交量A1.aveprice_amt,--上月均价A1.act_deal,--上月供求比A1.stock_qty/A2.deal_qty_avg qhzq,--上月去化周期A1.sell_rate_pct,--上月平均去化率A7.deal_qty_p,--成交量平均数A7.deal_qty_b,--成交量标准差A7.aveprice_amt_p,--成交均价平均数A7.aveprice_amt_b,--成交均价标准差A7.act_deal_p,--供求比平均数A7.act_deal_b--供求比标准差from (select region_id,city_id,deal_qty,aveprice_amt,(case when deal_qty=0 then 0 else act_str/deal_qty end) as act_deal,sell_rate_pct,stock_qty from dc_market_vol_city_f WHERE left(month_date,4)+'-'+right(month_date,2) = convert(varchar(7),DATEADD(mm, -1, GETDATE()),120) --取上个月各城市量价存等数据) A1INNER JOIN(select region_id,city_id,SUM(deal_qty)/6 deal_qty_avgfrom dc_market_vol_city_fwhere month_date >=  convert(varchar(7),DATEADD(mm, -7, GETDATE()),120)andmonth_date <= convert(varchar(7),DATEADD(mm, -1, GETDATE()),120)GROUP BY region_id,city_id--前六个月数据) A2ON A1.city_id = A2.city_idLEFT JOIN(select region_id,city_id,deal_qty,aveprice_amt,(case when deal_qty=0 then 0 else act_str/deal_qty end) as act_deal,sell_rate_pct,stock_qtyfrom dc_market_vol_city_f WHERE left(month_date,4)+'-'+right(month_date,2) = convert(varchar(7),DATEADD(mm, -2, GETDATE()),120)--取上上个月各城市量价存等数据，用于计算同环比) A3ON A1.city_id = A3.city_idLEFT JOIN(select region_id,city_id,deal_qty,aveprice_amt,(case when deal_qty=0 then 0 else act_str/deal_qty end) as act_deal,sell_rate_pct,stock_qtyfrom dc_market_vol_city_f WHERE left(month_date,4)+'-'+right(month_date,2) = convert(varchar(7),DATEADD(mm, -13, GETDATE()),120)--取去年上个月成交量数据，用于计算同比) A4ON A1.city_id = A4.city_id INNER JOIN ( select  region_id,city_id, SUM(deal_qty)/6 deal_qty_avg from dc_market_vol_city_f where  month_date >=  convert(varchar(7),DATEADD(mm, -8, GETDATE()),120) and month_date <= convert(varchar(7),DATEADD(mm, -2, GETDATE()),120) GROUP BY region_id,city_id--上个月前六个月数据) A5ON A1.city_id = A5.city_idINNER JOIN(select region_id,city_id,SUM(deal_qty)/6 deal_qty_avgfrom dc_market_vol_city_fwhere month_date >=  convert(varchar(7),DATEADD(mm, -19, GETDATE()),120)andmonth_date <= convert(varchar(7),DATEADD(mm, -13, GETDATE()),120)GROUP BY region_id,city_id--去年同期前六个月数据) A6ON A1.city_id = A6.city_idINNER JOIN(select region_id,city_id,sum(deal_qty)/36 deal_qty_p,stdev(deal_qty) deal_qty_b,sum(aveprice_amt)/36 aveprice_amt_p,stdev(aveprice_amt) aveprice_amt_b,sum(act_str/deal_qty)/36 act_deal_p,stdev(act_str/deal_qty) act_deal_bfrom dc_market_vol_city_f where month_date >=  convert(varchar(7),DATEADD(mm, -37, GETDATE()),120)andmonth_date <= convert(varchar(7),DATEADD(mm, -1, GETDATE()),120)GROUP BY region_id,city_id--前36个月数据) A7ON A1.city_id = A7.city_id where A1.city_id = '320800'

  579个浏览 1个回答 FineReport 2019年02月22日发布
• 
  报表地图问题

  地图边界:我这里面可选择的文件夹有多个我需要的是"地理信息"这个文件夹,这个文件夹下包含各省市的地理信息,为什么我选不中"地理信息"这个文件夹呢?大佬们,有什么技巧吗?

  369个浏览 1个回答 FineReport 2019年02月27日发布

66

5

66

10