report.ini

提供商业企业进销存、成本核算、销售人员工资考核结算、地区管理报表（特别是二维报表）

release 9;
datawindow ( units=0 timer_interval=0 color=1073741824 processing=1 print.printername=""  print.documentname=""  print.orientation=0 print.margin.left=110 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 print.paper.size=0 print.paper.source=0 print.canusedefaultprinter=yes grid.lines=0 selected.mouse=yes)
header(height=204 color="536870912" )
summary(height=88 color="536870912" )
footer(height=0 color="536870912" )
detail(height=100 color="536870912" )
table(column=(type=char(9) updatewhereclause=yes name=sgoods_code dbname="sgoods_code"  )
column=(type=char(2) updatewhereclause=yes name=sgoods_name dbname="sgoods_name" 
 values=""  )
column=(type=char(3) updatewhereclause=yes name=strademark dbname="strademark" 
 values=""  )
column=(type=char(2) updatewhereclause=yes name=sclass dbname="sclass" 
 values=""  )
column=(type=char(2) updatewhereclause=yes name=stype dbname="stype" 
 values=""  )
column=(type=char(2) updatewhereclause=yes name=sstock_code dbname="sstock_code" 
 values=""  )
column=(type=decimal(2) updatewhereclause=yes name=ssumbgty dbname="ssumbgty"  )
column=(type=decimal(2) updatewhereclause=yes name=sinqty dbname="sinqty"  )
column=(type=decimal(2) updatewhereclause=yes name=smove dbname="smove"  )
column=(type=decimal(2) updatewhereclause=yes name=soutqty dbname="soutqty"  )
column=(type=decimal(2) updatewhereclause=yes name=smove_out dbname="smove_out"  )
column=(type=decimal(2) updatewhereclause=yes name=sendqty dbname="sendqty"  )
 retrieve=" 

 select a.sgoods_code,a.sgoods_name,a.strademark,a.sclass,
         a.stype,a.sstock_code, isnull(n.sumbgty,0)  as ssumbgty,isnull(b.inqty,0)  as sinqty,
         isnull(d.move_in,0)  as smove,isnull(c.outqty,0)  as soutqty,isnull(e.move_out,0)  as smove_out,
        (isnull(n.sumbgty,0) + isnull(b.inqty,0) + isnull(d.move_in,0) - isnull(c.outqty,0) - isnull(e.move_out,0)) as sendqty
  from  
 (select goods_dict.goods_code as sgoods_code,goods_dict.goods_name as sgoods_name,
         goods_dict.trademark as strademark,goods_dict.class as sclass,
         goods_dict.type as stype,stock_dict.stock_code  as sstock_code  
 from stock_dict, goods_dict)   as a 
  left outer join
  (SELECT bill_det.goods_code, bill_mst.stock_code,  
          sum(isnull(bill_det.qty,0)) as inqty   
    FROM bill_det,   
         bill_mst  
   WHERE ( bill_det.bill_no = bill_mst.bill_no )           and  
         ( bill_mst.bill_date between :bgdt  and :eddt )   and
         (charge_indicator is null or charge_indicator=1)  and
          bill_mst.type='in'   
         group by bill_det.goods_code, bill_mst.stock_code) as  b
  on a.sgoods_code=b.goods_code and b.stock_code=a.sstock_code
  left outer join 
    (SELECT bill_det.goods_code, bill_mst.stock_code,   
          sum(isnull(bill_det.qty,0)) as outqty   
    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )           and  
         ( bill_mst.bill_date between :bgdt  and :eddt )    and
          bill_mst.bill_rp<>'04'                            and
         (charge_indicator is null or charge_indicator=1)   and
          bill_mst.type='ou'   
          group by bill_det.goods_code, bill_mst.stock_code)  as c
   on a.sgoods_code=c.goods_code and c.stock_code=a.sstock_code
   left outer join 
    (SELECT bill_det.goods_code,bill_mst.stock_out as stock_code,    
          sum(isnull(bill_det.qty,0)) as move_in   
    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )           and  
         ( bill_mst.bill_date between :bgdt  and :eddt )    and
          bill_mst.bill_rp='04'                             and
         (charge_indicator is null or charge_indicator=1)   and
          bill_mst.type='mo'                                
          group by bill_det.goods_code, bill_mst.stock_out)  as d
   on a.sgoods_code=d.goods_code and d.stock_code=a.sstock_code 
   left outer join 
    (SELECT bill_det.goods_code, bill_mst.stock_code,   
          sum(isnull(bill_det.qty,0)) as move_out   
    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )          and  
         ( bill_mst.bill_date between :bgdt  and :eddt )   and
          bill_mst.bill_rp='04'                            and
         (charge_indicator is null or charge_indicator=1)  and
          bill_mst.type='mo'   
          group by bill_det.goods_code, bill_mst.stock_code) as  e
 on a.sgoods_code=e.goods_code and e.stock_code=a.sstock_code 
 left outer join
   (select m.goods_code,vstock , 
        sum(isnull(m.bqty,0)) as  sumbgty
    from
   (SELECT bill_det.goods_code,bill_mst.stock_code  as vstock  ,
          sum(isnull(bill_det.qty,0)) as bqty