• 
  请问为什么查询结果是空呢

  数据库里面是有数据的，但是查询到结果就是空代码如下select sum(amount)/10000 as 微信月支付from app_db.payinfo_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'_','')  and mpay_type_txt  = "微信"

  370个浏览 3个回答 FineReport 2022年05月19日发布
• 
  请问为什么这里会报错

  SELECT a.mpay_type_txt,a.银联卡日支付, b.银联卡月支付, c.银联卡年支付FROM (select mpay_type_txt, sum(amount)/10000 as '银联卡日支付' from lsyw_yp_payinfo_d_hy group by mpay_type_txtwhere calday =translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','') and mpay_type_txt="银联卡")afull joinfrom(select mpay_type_txt, sum(amount)/10000 as '银联卡月支付' from lsyw_yp_payinfo_hy group by mpay_type_txtwhere calmonth =translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,7 ),'-','') and mpay_type_txt="银联卡")bon a.mpay_type_txt = b.mpay_type_txtfull join(select mpay_type_txt, sum(amount)/10000 as '银联卡年支付' from lsyw_yp_payinfo_d_hy group by mpay_type_txtwhere calday =translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,4 ),'-','') and mpay_type_txt="银联卡")con a.mpay_type_txt =c.mpay_type_txt

  234个浏览 1个回答 FineReport 2022年05月18日发布
• 
  请问为什么报错啊？

  代码如下，SELECT calmonth,mpay_type_txt,sum(amount)/10000 FROM app_db.zhy_fyyw_fy_payinfo_hy  where calmonth=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,7 ) and mpay_type_txt!="总金额" group by mpay_type_txt

  164个浏览 1个回答 FineReport 2022年05月17日发布
• 
  请问这是为啥出错啊

  代码如下select '销量', a.xy,a.ax,a.zx from(select xy_sale as xy, ax_sale as ax, zx_sale as zx from app_db.yp_xs_d_his_hy where calday=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','')) as aunion select '收入', a.xy,a.ax,a.zx from(select xy_income as xy, ax_income as ax, zx_income as zx from app_db.yp_xs_d_his_hy where calday=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','')) as aunion select '毛利', a.xy,a.ax,a.zx from(select xy_gross as xy, ax_gross as ax, zx_gross as zx from app_db.yp_xs_d_his_hy where calday=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','')) as a

  333个浏览 3个回答 FineReport 2022年05月16日发布
• 
  请问如何给这个地方命名

  想将这个地方命名为类型，但是不知道怎么改，代码如下select'本月',a.值from (select by_income as  值 from app_db.zhy_fyyw_xl_m_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'-','')) as aunionselect'上月',a.值from (select sy_income as  值 from app_db.zhy_fyyw_xl_m_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'-','')) as aunionselect'同期',a.值from (select tq_income as  值 from app_db.zhy_fyyw_xl_m_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'-','')) as aunionselect'同比',a.值from (select tb_income_rate as  值 from app_db.zhy_fyyw_xl_m_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'-','')) as aunionselect'环比',a.值from (select hb_income_rate as  值 from app_db.zhy_fyyw_xl_m_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'-','')) as a

  240个浏览 2个回答 FineReport 2022年05月16日发布
• 
  请问这是为什么

  340个浏览 2个回答 FineReport 2022年05月10日发布
• 
  请问为什么总报错啊

  代码如下select a.settle_day, a.'销售额度', b.'利润金额'from(select ,settle_day,sum(sum_oil_volume) as "销售额度" from app_b04.dit_ci00004_hy where  oil_type = "301001"   group by settle_day)afull join(select sum(sum_oil_volume) as "利润金额",settle_day from app_b04.dit_ci00004_hy where  oil_type = "301002" group by settle_day)bon a.settle_day =b.settle_daygroup by a.settle_day

  258个浏览 2个回答 FineReport 2022年05月10日发布
• 
  如何选表格将这个图表美化一点

  如图，请问怎么做会美化一些呢？

  562个浏览 4个回答 FineReport 2021年11月09日发布
• 
  请问这是什么问题

  232个浏览 2个回答 FineReport 2022年03月29日发布
• 
  决策报表如何用标签按钮打开另一个决策报表

  如图我想用这个打开另一章报表请问我应该怎么设置呢？我用了url写入了我的文件路径之后跳出404又是为什么？

  285个浏览 3个回答 FineReport 2022年03月11日发布

149

3

149

10