Q5/ws_objects/Ew_printbill.pbl.src/dw_rp_invoicemx_index.srd

$PBExportHeader$dw_rp_invoicemx_index.srd
release 9;
datawindow ( units=1 timer_interval=0 color=1073741824 processing=1 print.orientation=0 print.margin.left=24 print.margin.right=24 print.margin.top=24 print.margin.bottom=24 print.paper.size=0 print.paper.source=0 grid.lines=0 selected.mouse=yes)
header(height=19 color="536870912" )
summary(height=0 color="536870912" )
footer(height=17 color="536870912" )
detail(height=20 color="536870912" )
table(column=(type=long key=yes update=yes updatewhereclause=yes initial="null" name=scid dbname="u_invoicemx.scid" 
 values="分部ID	/"  )
column=(type=long key=yes update=yes updatewhereclause=yes initial="null" name=invoiceid dbname="u_invoicemx.invoiceid" 
 values="单据ID	/"  )
column=(type=long update=yes updatewhereclause=yes initial="null" name=mtrlid dbname="u_invoicemx.MtrlID" 
 values="产品ID	/"  )
column=(type=char(20) update=yes updatewhereclause=yes initial="null" name=mtrlcode dbname="u_invoicemx.mtrlcode"  )
column=(type=char(50) update=yes updatewhereclause=yes initial="null" name=mtrlname dbname="u_invoicemx.mtrlname"  )
column=(type=decimal(4) update=yes updatewhereclause=yes initial="null" name=qty dbname="u_invoicemx.Qty"  )
column=(type=decimal(4) update=yes updatewhereclause=yes initial="null" name=amt dbname="u_invoicemx.amt"  )
column=(type=char(255) update=yes updatewhereclause=yes initial="null" name=dscrp dbname="u_invoicemx.dscrp"  )
column=(type=long key=yes update=yes updatewhereclause=yes initial="null" name=printid dbname="u_invoicemx.printid"  )
column=(type=decimal(10) update=yes updatewhereclause=yes initial="null" name=price dbname="u_invoicemx.price"  )
 retrieve="SELECT u_invoicemx.scid,   
         u_invoicemx.invoiceid,   
         u_invoicemx.MtrlID,   
         u_invoicemx.mtrlcode,   
         u_invoicemx.mtrlname,   
         u_invoicemx.Qty,   
         u_invoicemx.amt,     
         u_invoicemx.dscrp,    
         u_invoicemx.printid,      
         u_invoicemx.price  
    FROM u_invoicemx  
   WHERE ( u_invoicemx.scid = :arg_scid ) AND  
         ( u_invoicemx.invoiceid = :arg_invoiceid )  and
 			( :arg_printrow = :arg_printrow ) and
			( :arg_top = :arg_top )
            
"
  update="u_invoicemx" updatewhere=1 updatekeyinplace=no
  arguments=(("arg_scid", number), ("arg_invoiceid", number), ("arg_printrow", number), ("arg_top", number))
)
text(name=mtrlcode_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="28" y="2" height="15" width="146" text="编码" )
text(name=mtrlname_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="176" y="2" height="15" width="144" text="品名" )
text(name=qty_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="322" y="2" height="15" width="67" text="数量" )
text(name=amt_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="391" y="2" height="15" width="65" text="金额" )
text(name=dscrp_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="545" y="2" height="15" width="147" text="明细备注" )
text(name=printid_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="2" y="2" height="15" width="24" text="序" )
text(name=price_t visible="1" band=header font.charset="0" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="458" y="2" height="15" width="85" text="单价" )
text(name=t_1 visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="2" background.color="1073741824" color="33554432" alignment="2" border="0" x="28" y="1" height="15" width="146" text="合计" )
compute(name=compute_1 visible="1" tag="count(mtrlname for all)" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="176" y="1" height="15" width="144" format="[general]" expression="count(mtrlname for all)" alignment="2" border="0" crosstab.repeat=no )
compute(name=compute_2 visible="1" tag="sum(qty for all)" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="322" y="1" height="15" width="67" format="[general]" expression="sum(qty for all)" alignment="1" border="0" crosstab.repeat=no )
compute(name=compute_3 visible="1" tag="sum(amt for all)" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="391" y="1" height="15" width="65" format="[general]" expression="sum(amt for all)" alignment="1" border="0" crosstab.repeat=no )
column(name=mtrlcode visible="1" tag="mtrlcode" band=detail id=4 x="28" y="2" height="17" width="146" color="33554432" border="0" alignment="0" format="[general]" protect="0" 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=20 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=20 )
column(name=mtrlname visible="1" tag="mtrlname" band=detail id=5 x="176" y="2" height="17" width="144" color="33554432" border="0" alignment="0" format="[general]" protect="0" 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=50 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=30 )
column(name=dscrp visible="1" tag="dscrp" band=detail id=8 x="545" y="2" height="17" width="147" color="33554432" border="0" alignment="0" format="[general]" protect="0" 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=100 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=70 )
column(name=printid visible="1" tag="printid" band=detail id=9 x="2" y="2" height="17" width="24" color="33554432" border="0" alignment="2" format="[general]" protect="0" 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=10 )
column(name=price visible="1" tag="price" band=detail id=10 x="458" y="2" height="17" width="85" color="33554432" border="0" alignment="1" format="#,##0.0#########" protect="0" 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=60 )
column(name=qty visible="1" tag="qty" band=detail id=6 x="322" y="2" height="17" width="67" color="33554432" border="0" alignment="1" format="###0.###" protect="0" 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=40 )
column(name=amt visible="1" tag="amt" band=detail id=7 x="391" y="2" height="17" width="65" color="33554432" border="0" alignment="1" format="###0.00###" protect="0" 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="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=50 )
htmltable()
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )