• 
  点击按钮统计分数怎么实现

  543个浏览 1个回答 FineReport 2022年05月26日发布
• 
  怎么去掉多余的C，D，而且之间的空隙怎么缩小

  408个浏览 1个回答 FineReport 2022年05月12日发布
• 
  有些选项为空，不用加从C,D,怎么自动去掉

  388个浏览 2个回答 FineReport 2022年06月01日发布
• 
  有些题目是单选，我这样做所有的都可以多选怎么解决

  412个浏览 1个回答 FineReport 2022年06月01日发布
• 
  优化sql语句

  SELECT h.customer_po_number --客户PO      ,h.order_number --订单编号      ,h.order_type_name --订单类型      ,h.suit_count --套数      ,h.order_status_name --状态      ,to_char(h.booked_date,'yyyy-mm-dd') booked_date--订单受理日期      ,to_char(h.delivery_date,'yyyy-mm-dd') delivery_date --订单发货日期      ,to_char(h.creation_date,'yyyy-mm-dd') creation_date  --订单创建日期       ,to_char(h.complete_date,'yyyy-mm-dd') complete_date  --订单完工日期       ,h.zq --战区      ,h.sq --省区      ,h.pq --片区      ,h.city --城市    /*  ,h.segment1      ,h.segment2      ,h.segment3*/      ,h.account_number --客户编码      ,h.account_short_name --客户简称         ,h.promotion_name --活动      ,h.style_series --风格系列  ,ooh.order_progress as 进展    --,hfv.confirmed_name as 核价员    ,oe.design_method as 设计方式    ,oe.end_cust_name -- 终端客户地址     ,oe.end_cust_phone -- 终端客户电话       ,oe.end_cust_address -- 终端客户地址     ,SUM(decode(l.item_class,'MM',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS mm --木门    ,SUM(decode(l.item_class,'LKM',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS LKM--铝框门款        ,SUM(decode(l.item_class,'QB',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS QB --墙板款     ,SUM(decode(l.item_class,'MMYB',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS MMYB --岩板款      ,SUM(decode(l.item_class,'PTCP',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS PTCP-- 配套款    ,SUM(decode(l.item_class,'WJPJ',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS WJPJ-- 五金配件款      ,SUM(decode(l.item_class,'CPJJ',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS CPJJ-- 成品家居款6           , SUM(decode(l.item_class,'YYWPM',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS YYWPM-- 运动款    ,SUM(decode(l.item_class,'MMSP',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS MMSP -- 饰品款  ,SUM(CASE WHEN l.item_class NOT IN                  ('MM','LKM','QB', 'MMYB','PTCP','WJPJ','CPJJ', 'YYWPM','MMSP' ) THEN               nvl(l.yg_order_amount, 0) - nvl(l.charge_amount, 0)                        ELSE              0  END ) AS qy             FROM apps.cux_om_order_headers_v h      ,apps.cux_om_order_lines_v   l  ,mdm_cust_finerpt_user_access fu   ,oms_oe_order_types       ooot       ,oms_oe_order_headers ooh --添加进展         --,APPS.OMS_OE_ORDER_HEADER_FINE_V hfv--添加核价员          ,oms_oe_order_header_atts oe --添加终端      WHERE       h.header_id = l.header_id and l.header_id=ooh.header_id               and ooh.header_id=oe.header_id       --and oe.header_id =hfv.header_id        AND h.order_type_id = ooot.order_type_id and ooot.order_type_id=ooh.order_type_id (+)             --AND ooot.LEFT_FLAG = 'N' --是否遗留单:Y:是，N:否       AND ooot.CHANGE_FLAG = 'N'--是否更改单:Y:是，N:否       AND   h.unit_code =161       AND FU.ORG_ID=H.unit_code${if(len(BookDates)=0,"","and h.booked_date>=to_date('"+BookDates+"','yyyy-mm-dd')")}${if(len(BookDatee)=0,"","and h.booked_date<to_date('"+BookDatee+"','yyyy-mm-dd')+1")}${if(len(BookDates_c)=0,"","and h.creation_date>=to_date('"+BookDates_c+"','yyyy-mm-dd')")}${if(len(BookDatee_c)=0,"","and h.creation_date<to_date('"+BookDatee_c+"','yyyy-mm-dd')+1")} ${if(len(sq)==0,"", "and h.sq in ('" + replace(sq,",","','") + "')")} ${if(len(po) == 0,"","and  h.customer_po_number  like '%"+po+"%'")} --添加订单类型过滤  ${if(len(订单类型)==0,"","and h.order_type_name like '%"+订单类型+"%'")}  --添加客户简称过滤  ${if(len(客户简称)==0,"","and h.account_short_name like '%"+客户简称+"%'")}--添加订单编号过滤  ${if(len(订单编号)==0,"","and h.order_number  like '%"+订单编号+"%'")} AND h.order_type_name not  like '%遗留%'  AND h.order_type_name not  like '%厂部%' AND h.order_type_name not  like '%运营物品%' AND h.header_id = l.header_id--AND (fu.is_qd='N' OR fu.is_qd='A' OR h.site_code='1' )GROUP BY   h.customer_po_number --客户PO      ,h.order_number --订单编号      ,h.order_type_name --订单类型      ,h.suit_count --套数      ,h.order_status_name --状态      ,to_char(h.creation_date,'yyyy-mm-dd') --订单创建日期       ,to_char(h.booked_date,'yyyy-mm-dd') --订单受理日期      ,to_char(h.complete_date,'yyyy-mm-dd')  --订单完工日期       ,to_char(h.delivery_date,'yyyy-mm-dd')  --订单发货日期      ,h.zq --战区      ,h.sq --省区      ,h.pq --片区      ,h.city --城市      ,h.account_number --客户编码      ,h.account_short_name --客户简称         ,h.promotion_name --活动      ,h.style_series --风格系列         ,ooh.order_progress   --进展           --,hfv.confirmed_name -- 核价员         ,oe.design_method --设计方式            ,oe.end_cust_name -- 终端客户地址         ,oe.end_cust_phone -- 终端客户电话          ,oe.end_cust_address -- 终端客户地址                    我这个代加载的好慢，是SQL、语句的问题还是服务器卡？

  476个浏览 5个回答 FineReport 2022年05月27日发布
• 
  怎么把这一列数据集用中文展示

  480个浏览 5个回答 FineReport 2022年05月27日发布
• 
  数据集里怎么截取成这三个字符串

  379个浏览 3个回答 FineReport 2022年05月25日发布
• 
  数据集里怎么写可以让日期不为空的情况下再执行这个代码，为空就不用这个条件

  SELECT h.customer_po_number --客户PO      ,h.order_number --订单编号      ,h.order_type_name --订单类型      ,h.suit_count --套数      ,h.order_status_name --状态      ,to_char(h.booked_date,'yyyy-mm-dd') booked_date--订单受理日期      ,to_char(h.delivery_date,'yyyy-mm-dd') delivery_date --订单发货日期      ,to_char(h.creation_date,'yyyy-mm-dd') creation_date  --订单创建日期       ,to_char(h.complete_date,'yyyy-mm-dd') complete_date  --订单完工日期       ,h.zq --战区      ,h.sq --省区      ,h.pq --片区      ,h.city --城市    /*  ,h.segment1      ,h.segment2      ,h.segment3*/      ,h.account_number --客户编码      ,h.account_short_name --客户简称         ,h.promotion_name --活动      ,h.style_series --风格系列  ,ooh.order_progress as 进展    --,hfv.confirmed_name as 核价员    ,oe.design_method as 设计方式    ,oe.end_cust_name -- 终端客户地址     ,oe.end_cust_phone -- 终端客户电话       ,oe.end_cust_address -- 终端客户地址     ,SUM(decode(l.item_class,'MM',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS mm --木门    ,SUM(decode(l.item_class,'LKM',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS LKM--铝框门款        ,SUM(decode(l.item_class,'QB',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS QB --墙板款     ,SUM(decode(l.item_class,'MMYB',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS MMYB --岩板款      ,SUM(decode(l.item_class,'PTCP',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS PTCP-- 配套款    ,SUM(decode(l.item_class,'WJPJ',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS WJPJ-- 五金配件款      ,SUM(decode(l.item_class,'CPJJ',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS CPJJ-- 成品家居款6           , SUM(decode(l.item_class,'YYWPM',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS YYWPM-- 运动款    ,SUM(decode(l.item_class,'MMSP',nvl(l.yg_order_amount ,0) - nvl(l.charge_amount ,0),0)) AS MMSP -- 饰品款  ,SUM(CASE WHEN l.item_class NOT IN                  ('MM','LKM','QB', 'MMYB','PTCP','WJPJ','CPJJ', 'YYWPM','MMSP' ) THEN               nvl(l.yg_order_amount, 0) - nvl(l.charge_amount, 0)                        ELSE              0  END ) AS qy             FROM apps.cux_om_order_headers_v h      ,apps.cux_om_order_lines_v   l  ,mdm_cust_finerpt_user_access fu   ,oms_oe_order_types       ooot       ,oms_oe_order_headers ooh --添加进展         --,APPS.OMS_OE_ORDER_HEADER_FINE_V hfv--添加核价员          ,oms_oe_order_header_atts oe --添加终端      WHERE       h.header_id = l.header_id and l.header_id=ooh.header_id               and ooh.header_id=oe.header_id       --and oe.header_id =hfv.header_id        AND h.order_type_id = ooot.order_type_id and ooot.order_type_id=ooh.order_type_id (+)             --AND ooot.LEFT_FLAG = 'N' --是否遗留单:Y:是，N:否       AND ooot.CHANGE_FLAG = 'N'--是否更改单:Y:是，N:否       AND   h.unit_code =161       AND FU.ORG_ID=H.unit_code  ${if(len(BookDates)==0,"","  and  h.booked_date >='"+BookDates+"'")}  ${if(len(BookDatee)==0,"","  and  h.booked_date  ${if(len(BookDatee_c)==0,"","  and  h.creation_date${if(len(bookdatee)=0,"","and h.booked_date${if(len(bookdatee_c)=0,"","and h.creation_date  --${if(len(BookDatee_c)==0,"","  and  h.creation_date${if(len(bookdatee)=0,"","and l.cancelled_date${if(len(bookdatee_c)=0,"","and h.creation_date${if(len(bookdatee)=0,"","and l.cancelled_date${if(len(bookdatee_c)=0,"","and h.creation_date<to_date('"+bookdatee_C+"','yyyy-mm-dd')+1")} ${if(len(sq)==0,"", "and h.sq in ('" + replace(sq,",","','") + "')")} ${if(len(po) == 0,"","and  h.customer_po_number  like '%"+po+"%'")}  --添加订单类型过滤  ${if(len(订单类型)==0,"","and h.order_type_name like '%"+订单类型+"%'")}  --添加客户简称过滤  ${if(len(客户简称)==0,"","and h.account_short_name like '%"+客户简称+"%'")}--添加订单编号过滤  ${if(len(订单编号)==0,"","and h.order_number  like '%"+订单编号+"%'")} AND h.order_type_name not  like '%遗留%'  AND h.order_type_name not  like '%厂部%' AND h.order_type_name not  like '%运营物品%' AND h.header_id = l.header_id --AND (fu.is_qd='N' OR fu.is_qd='A' OR h.site_code='1' )GROUP BY   h.customer_po_number --客户PO      ,h.order_number --订单编号      ,h.order_type_name --订单类型      ,h.suit_count --套数      ,h.order_status_name --状态      ,to_char(h.creation_date,'yyyy-mm-dd') --订单创建日期       ,to_char(h.booked_date,'yyyy-mm-dd') --订单受理日期      ,to_char(h.complete_date,'yyyy-mm-dd')  --订单完工日期       ,to_char(h.delivery_date,'yyyy-mm-dd')  --订单发货日期      ,h.zq --战区      ,h.sq --省区      ,h.pq --片区      ,h.city --城市      ,h.account_number --客户编码      ,h.account_short_name --客户简称         ,h.promotion_name --活动      ,h.style_series --风格系列          ,ooh.order_progress   --进展        --,hfv.confirmed_name -- 核价员          ,oe.design_method --设计方式             ,oe.end_cust_name -- 终端客户地址         ,oe.end_cust_phone -- 终端客户电话          ,oe.end_cust_address -- 终端客户地址 

  394个浏览 2个回答 FineReport 2022年05月21日发布
• 
  在数据集里怎么写能汇总带有条件的金额，这两种方法都不行

  select h.CUSTOMER_PO_NUMBER as 客户PO,h.ORDER_NUMBER as 生产编号,ooot.ORDER_TYPE_NAME as 订单类型,v.ACCOUNT_SHORT_NAME as 客户简称,atts.suit_count as 套数,h.order_status as 订单状态,h.order_progress as 订单进展,to_char(h.creation_date,'yyyy-mm-dd')as 订单创建日期,to_char(h.BOOKED_DATE,'yyyy-mm-dd') as 订单受理日期,to_char(h.complete_date,'yyyy-mm-dd') as 订单完工日期,to_char(l.delivery_date,'yyyy-mm-dd') as 订单发货日期,tv.meaning1 as 大区,tv.meaning2 as 省区,tv.meaning3 as 片区,tv.MEANING as 城市,v.ACCOUNT_NUMBER as 客户编号,atts.STYLE_SERIES as 订单风格,atts.PROMOTION_HEADER_ID as 促销活动,--SUM(decode(l.item_class,'MM',nvl(l.UNIT_PRICE,0) ,0)) AS 木门, --木门count(case when l.item_class='MM' then l.UNIT_PRICE else null end) as 木门fromAPPS.OMS_OE_ORDER_HEADERS h,APPS.OMS_OE_ORDER_TYPES ooot,apps.cux_om_order_headers_v v,APPS.OMS_OE_ORDER_HEADER_ATTS atts,apps.mdm_cust_territory_solutions_v tv,APPS.OMS_OE_ORDER_LINES lwhere 1=1${if(len(订单类型)==0,"","and ooot.ORDER_TYPE_NAME='"+订单类型+"'")}${if(len(订单编号)==0,"","and h.ORDER_NUMBER='"+订单编号+"'")}${if(len(po)==0,"","and h.CUSTOMER_PO_NUMBER='"+po+"'")}${if(len(客户简称)==0,"","and v.ACCOUNT_SHORT_NAME='"+客户简称+"'")}${if(len(sq)==0,"","and tv.meaning2 in ('"+sq+"')")}${if(len(BookDates)=0,""," and to_char(h.BOOKED_DATE,'yyyy-mm-dd')>='"+BookDates+"'")} ${if(len(BookDatee)=0,""," and to_char(h.BOOKED_DATE,'yyyy-mm-dd')${if(len(BookDatee_c)=0,""," and to_char(h.creation_date,'yyyy-mm-dd')<='"+BookDatee_c+"'")} and v.order_type_id=ooot.order_type_id and ooot.order_type_id=h.order_type_idand h.header_id=atts.header_id and atts.header_id=v.header_id and v.header_id=l.header_id and h.UNIT_ID=tv.UNIT_ID and tv.UNIT_ID=ooot.UNIT_ID and ooot.UNIT_ID=v.UNIT_IDand v.UNIT_ID=l.UNIT_IDand h.ACCOUNT_SITE_ID=v.ACCOUNT_SITE_IDand h.TERRITORY_ID=v.TERRITORY_ID and v.TERRITORY_ID=tv.TERRITORY_ID--and ooot.CREATED_BY=atts.CREATED_BYgroup byh.CUSTOMER_PO_NUMBER ,h.ORDER_NUMBER ,ooot.ORDER_TYPE_NAME ,v.ACCOUNT_SHORT_NAME,atts.suit_count,h.order_status,h.order_progress,h.creation_date,h.BOOKED_DATE,h.complete_date,tv.meaning2,l.delivery_date,tv.meaning1,tv.meaning3,tv.MEANING,v.ACCOUNT_NUMBER,atts.STYLE_SERIES,atts.PROMOTION_HEADER_ID

  390个浏览 3个回答 FineReport 2022年05月17日发布
• 
  一个省区的数据占一行，现在这样怎么解决

  这是数据集里的sql语句select h.CUSTOMER_PO_NUMBER as 客户PO,h.ORDER_NUMBER as 生产编号,ooot.ORDER_TYPE_NAME as 订单类型,v.ACCOUNT_SHORT_NAME as 客户简称,atts.suit_count as 套数,h.order_status as 订单状态,h.order_progress as 订单进展,h.creation_date as 订单创建日期,h.BOOKED_DATE as 订单受理日期,h.complete_date as 订单完工日期,tv.meaning2 as 省区fromAPPS.OMS_OE_ORDER_HEADERS h,APPS.OMS_OE_ORDER_TYPES ooot,apps.cux_om_order_headers_v v,APPS.OMS_OE_ORDER_HEADER_ATTS atts,apps.mdm_cust_territory_solutions_v tvwhere 1=1${if(len(订单类型)==0,"","and ooot.ORDER_TYPE_NAME='"+订单类型+"'")}${if(len(订单编号)==0,"","and h.ORDER_NUMBER='"+订单编号+"'")}${if(len(po)==0,"","and h.CUSTOMER_PO_NUMBER='"+po+"'")}${if(len(客户简称)==0,"","and v.ACCOUNT_SHORT_NAME='"+客户简称+"'")}${if(len(sq)==0,"","and tv.meaning2 in ('"+sq+"')")}and v.order_type_id=ooot.order_type_id and ooot.order_type_id=h.order_type_idand h.header_id=atts.header_id and atts.header_id=v.header_idgroup byh.CUSTOMER_PO_NUMBER ,h.ORDER_NUMBER ,ooot.ORDER_TYPE_NAME ,v.ACCOUNT_SHORT_NAME,atts.suit_count,h.order_status,h.order_progress,h.creation_date,h.BOOKED_DATE,h.complete_date,tv.meaning2

  348个浏览 3个回答 FineReport 2022年05月17日发布

20

19

20

10