report.ini

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

    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )          and  
         ( bill_mst.bill_date <:bgdt  )                    and
         (charge_indicator is null or charge_indicator=1)  and
          bill_mst.type='in' 
         group by  bill_det.goods_code,bill_mst.stock_code
    union
    SELECT bill_det.goods_code, bill_mst.stock_code  as vstock  ,   
          sum(isnull( 0 - bill_det.qty,0)) as bqty   
    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )          and  
         ( bill_mst.bill_date <:bgdt  )                    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 
    union
    SELECT bill_det.goods_code,bill_mst.stock_out as vstock ,    
        sum(isnull(bill_det.qty,0)) as bqty   
    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )           and  
         ( bill_mst.bill_date <:bgdt  )                     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
    union
    SELECT bill_det.goods_code, bill_mst.stock_code as vstock,   
        sum(isnull(-bill_det.qty,0)) as bqty   
    FROM bill_det,   
         bill_mst  
    WHERE ( bill_det.bill_no = bill_mst.bill_no )           and  
         ( bill_mst.bill_date <:bgdt  )                     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
   ) m 
       group by m.goods_code,m.vstock
   ) n
on a.sgoods_code=n.goods_code and  n.vstock=a.sstock_code
where (isnull(n.sumbgty,0)<>0 or isnull(b.inqty,0)<>0 or isnull(d.move_in,0)<>0  or  isnull(c.outqty,0)<>0 or isnull(e.move_out,0)<>0  
or  (isnull(n.sumbgty,0) + isnull(b.inqty,0) + isnull(d.move_in,0) - isnull(c.outqty,0) - isnull(e.move_out,0))<>0) and a.sgoods_name='03'  order by a.sgoods_code,a.sstock_code"  arguments=(("bgdt", datetime), ("eddt", datetime))
 sort="sgoods_code A, sstock_code A, sgoods_name A, strademark A, sclass A, stype A"
)
text(name=sgoods_code_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="9" y="120" height="76" width="448" text="编码" )
text(name=sgoods_name_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="466" y="120" height="76" width="462" text="品名" )
text(name=strademark_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="937" y="120" height="76" width="375" text="品牌" )
text(name=sclass_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="1321" y="120" height="76" width="215" text="类别" )
text(name=stype_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="1545" y="120" height="76" width="187" text="型号" )
text(name=sstock_code_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="1742" y="120" height="76" width="416" text="仓库" )
text(name=ssumbgty_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="2167" y="120" height="76" width="384" text="期初" )
text(name=sinqty_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="2560" y="120" height="76" width="384" text="入库" )
text(name=smove_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="2953" y="120" height="76" width="384" text="调 入" )
text(name=soutqty_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="3346" y="120" height="76" width="384" text="出库" )
text(name=smove_out_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="3739" y="120" height="76" width="384" text="调出" )
text(name=sendqty_t visible="1" band=header font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="4133" y="120" height="76" width="384" text="结存" )
text(name=t_2 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="9" y="8" height="76" width="448" text="合计:" )
compute(name=compute_7 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="2167" y="4" height="76" width="384" format="[GENERAL]" expression="sum(  ssumbgty  for all )" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_8 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="2560" y="4" height="76" width="384" format="[GENERAL]" expression="sum(  sinqty  for all )" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_9 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="2953" y="4" height="76" width="384" format="[GENERAL]" expression="sum(  smove  for all )" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_10 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="3346" y="4" height="76" width="384" format="[GENERAL]" expression="sum(  soutqty  for all )" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_11 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="3739" y="4" height="76" width="384" format="[GENERAL]" expression="sum(  smove_out  for all )" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_12 visible="1" band=summary font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="4133" y="4" height="76" width="384" format="[GENERAL]" expression="sum(  sendqty  for all )" alignment="0" border="0" crosstab.repeat=no )
column(name=sgoods_code visible="1" band=detail id=1 x="9" y="4" height="88" width="448" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=9 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=sgoods_name visible="1" band=detail id=2 x="466" y="4" height="88" width="462" color="33554432" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=name_code dddw.displaycolumn=name_type dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=dddw_name dddw.nilisnull=no dddw.percentwidth=0 dddw.required=no dddw.showlist=no dddw.vscrollbar=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=strademark visible="1" band=detail id=3 x="937" y="4" height="88" width="375" color="33554432" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=trademark_code dddw.displaycolumn=trademark_type dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=dddw_trademark dddw.nilisnull=no dddw.percentwidth=0 dddw.required=no dddw.showlist=no dddw.vscrollbar=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=sclass visible="1" band=detail id=4 x="1321" y="4" height="88" width="215" color="33554432" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=class_code dddw.displaycolumn=class_type dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=dddw_class dddw.nilisnull=no dddw.percentwidth=0 dddw.required=no dddw.showlist=no dddw.vscrollbar=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=stype visible="1" band=detail id=5 x="1545" y="4" height="88" width="187" color="33554432" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=brand_code dddw.displaycolumn=brand_type dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=dddw_brand_type dddw.nilisnull=no dddw.percentwidth=0 dddw.required=no dddw.showlist=no dddw.vscrollbar=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=sstock_code visible="1" band=detail id=6 x="1742" y="4" height="88" width="416" color="33554432" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=stock_code dddw.displaycolumn=stock_name dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=dddw_stock dddw.nilisnull=no dddw.percentwidth=0 dddw.required=no dddw.showlist=no dddw.vscrollbar=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=ssumbgty visible="1" band=detail id=7 x="2167" y="4" height="88" width="384" color="33554432" border="0" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=sinqty visible="1" band=detail id=8 x="2560" y="4" height="88" width="384" color="33554432" border="0" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=smove visible="1" band=detail id=9 x="2953" y="4" height="88" width="384" color="33554432" border="0" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=soutqty visible="1" band=detail id=10 x="3346" y="4" height="88" width="384" color="33554432" border="0" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=smove_out visible="1" band=detail id=11 x="3739" y="4" height="88" width="384" color="33554432" border="0" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=sendqty visible="1" band=detail id=12 x="4133" y="4" height="88" width="384" color="33554432" border="0" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=t_title visible="1" band=foreground font.charset="0" font.face="Arial" font.family="2" font.height="-12" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="0" border="0" x="5" y="12" height="76" width="1300" text="统计期间：自2006-10-01至2006-11-06" )
htmltable(border="1" )
htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0distill.customPostScript="0" xslfop.print="0" )