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

$PBExportHeader$dw_rp_inwaremx_sumamt.srd
release 9;
datawindow ( units=1 timer_interval=0 color=16777215 processing=0 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 selected.mouse=no)
header(height=0 color="?" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=17 color="536870912" )
table(column=(type=decimal(14) updatewhereclause=yes initial="null" name=amt dbname="amt" 
 values="Amt	/"  )
 retrieve="SELECT sum(round(u_inwaremx.price* u_inwaremx.qty,2)) + u_inware.otheramt as amt  
    FROM u_inware,u_inwaremx  
   WHERE ( u_inware.scid = u_inwaremx.scid ) and
			( u_inware.inwareid = u_inwaremx.inwareid ) and
			( u_inwaremx.inwareid = :arg_inwareid ) AND  
         ( u_inwaremx.scid = :arg_scid )   
group by u_inware.otheramt
"
  arguments=(("arg_scid", number), ("arg_inwareid", number))
)
text(name=t_1 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="3" y="1" height="15" width="124" text="合计金额(大写):" )
compute(name=compute_1 visible="1" tag="f_decimaltocn(abs(amt),0)" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="0" x="131" y="1" height="15" width="325" format="[general]" expression="f_decimaltocn(abs(amt),0)" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_2 visible="1" tag="'￥: '+string( amt ,'#,##0.00')" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="0" x="459" y="1" height="15" width="167" format="[general]" expression="'￥: '+string( amt ,'#,##0.00')" alignment="0" border="0" crosstab.repeat=no )
htmltable()
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )