Q5/ws_objects/cw_account.pbl.src/dw_rp_qty_mx.srd

$PBExportHeader$dw_rp_qty_mx.srd
$PBExportComments$By Kivens.Jiang(kivens@21cn.com)
release 9;
datawindow ( units=0 timer_interval=60000 color=16777215 processing=1 print.documentname=""  print.orientation=1 print.margin.left=110 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 print.paper.size=9 print.paper.source=0 grid.lines=0 selected.mouse=yes)
header(height=324 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=76 color="553648127"  height.autosize=yes)
table(column=(type=long updatewhereclause=yes name=cmonth dbname="cmonth"  )
column=(type=decimal(4) updatewhereclause=yes name=price dbname="price"  )
column=(type=decimal(4) updatewhereclause=yes name=damount dbname="damount"  )
column=(type=decimal(4) updatewhereclause=yes name=camount dbname="camount"  )
column=(type=decimal(2) updatewhereclause=yes name=debit dbname="debit"  )
column=(type=decimal(2) updatewhereclause=yes name=credit dbname="credit"  )
column=(type=char(255) updatewhereclause=yes name=brief dbname="brief"  )
column=(type=char(10) updatewhereclause=yes name=credtype dbname="credtype"  )
column=(type=long updatewhereclause=yes name=credno dbname="credno"  )
column=(type=datetime updatewhereclause=yes name=creddate dbname="creddate"  )
column=(type=long updatewhereclause=yes name=subaccsetid dbname="subaccsetid"  )
column=(type=decimal(2) updatewhereclause=yes name=balc dbname="balc"  )
column=(type=decimal(4) updatewhereclause=yes name=qtybalc dbname="qtybalc"  )
column=(type=long updatewhereclause=yes name=dw_sort dbname="dw_sort"  )
column=(type=long updatewhereclause=yes name=fuluno dbname="fuluno"  )
column=(type=long updatewhereclause=yes name=dcflag dbname="dcflag"  )
column=(type=long updatewhereclause=yes name=credid dbname="credid"  )
 retrieve="SELECT  top 1 NULL as cmonth,
	NULL as price,
	NULL as damount,
	NULL as camount,
	NULL as debit,
	NULL as credit,
	'期初余额' as brief,
	NULL as credtype,
	NULL as credno,
	NULL as creddate,
	NULL as subaccsetid,
	0.00 as balc,
	0.00 as qtybalc,
	0 as dw_sort,
	0 as fuluno,
	uv_qty_init.dcflag as dcflag,
	0 as credid
	FROM uv_qty_init left OUTER join uv_qty_mx  on
	uv_qty_init.accsetid = uv_qty_mx.accsetid AND
	uv_qty_init.subid = uv_qty_mx.subid
	WHERE ( uv_qty_init.accsetid = :arg_accsetid ) AND
	( uv_qty_init.subid = :arg_subid )

	UNION ALL
	SELECT uv_qty_mx.cmonth as cmonth,
	case uv_qty_mx.price when 0 then NULL else uv_qty_mx.price END as price,
	case uv_qty_mx.damount * uv_qty_mx.amount when 0 then NULL else uv_qty_mx.damount * uv_qty_mx.amount END as damount,
	case uv_qty_mx.camount * uv_qty_mx.amount when 0 then NULL else uv_qty_mx.camount * uv_qty_mx.amount END as camount,
	case uv_qty_mx.debit when 0 then NULL else uv_qty_mx.debit END as debit,
	case uv_qty_mx.credit when 0 then NULL else uv_qty_mx.credit END as credit,
	case :arg_rel when 1 then
         ltrim(rtrim(uv_qty_mx.brief)) + ' ' +
			case len(ltrim(rtrim(uv_qty_mx.reldcode))) when 0 then '' else '相关号:'+ltrim(rtrim(uv_qty_mx.reldcode)) end + ' '+
         case uv_qty_mx.reldate when null then '' else '相关日期:'+ convert(char(4),year(uv_qty_mx.reldate))+'-'+convert(char(2),month(uv_qty_mx.reldate))+'-'+ convert(char(2),day(uv_qty_mx.reldate)) end 
         else 
         ltrim(rtrim(uv_qty_mx.brief)) + ' ' +
			case len(ltrim(rtrim(uv_qty_mx.reldcode))) when 0 then '' else '相关号:'+ltrim(rtrim(uv_qty_mx.reldcode)) + ' '+
         case uv_qty_mx.reldate when null then '' else '相关日期:'+ convert(char(4),year(uv_qty_mx.reldate))+'-'+convert(char(2),month(uv_qty_mx.reldate))+'-'+ convert(char(2),day(uv_qty_mx.reldate)) end end end  as brief,   
	uv_qty_mx.credtype as credtype,
	uv_qty_mx.credno as credno,
	uv_qty_mx.creddate as creddate,
	uv_qty_mx.subaccsetid as subaccsetid,
	0.00 as balc,
	0.00 as qtybalc, 
	1 as dw_sort,
	uv_qty_mx.fuluno as fuluno,
	uv_qty_mx.dcflag as dcflag,
	uv_qty_mx.credid as credid
	FROM uv_qty_mx
	WHERE ( uv_qty_mx.accsetid = :arg_accsetid ) AND
	( uv_qty_mx.cmonth >= :arg_firstcmon ) AND
	( uv_qty_mx.cmonth <= :arg_endcmon ) AND
	( uv_qty_mx.subid like :arg_subid_like ) AND
	( uv_qty_mx.postflag = :arg_postflag OR :arg_postflag = -1 )
	
	
	UNION ALL
	SELECT uv_qty_mx.cmonth as cmonth,
	NULL as price,
	case sum(uv_qty_mx.damount * uv_qty_mx.amount) when 0 then NULL else sum(uv_qty_mx.damount * uv_qty_mx.amount) END as damount,
	case sum(uv_qty_mx.camount * uv_qty_mx.amount) when 0 then NULL else sum(uv_qty_mx.camount * uv_qty_mx.amount) END as camount,
	case sum(uv_qty_mx.debit) when 0 then NULL else sum(uv_qty_mx.debit) END as debit,
	case sum(uv_qty_mx.credit) when 0 then NULL else sum(uv_qty_mx.credit) END as credit,
	'本期合计' as brief,
	NULL as credtype,
	NULL as credno,
	NULL as creddate,
	NULL as subaccsetid,
	0.00 as balc,
	0.00 as qtybalc,
	2 as dw_sort,
	0 as fuluno,
	uv_qty_mx.dcflag as dcflag,
	0 as credid
	FROM uv_qty_mx
	WHERE ( uv_qty_mx.accsetid = :arg_accsetid ) AND
	( uv_qty_mx.cmonth >= :arg_firstcmon ) AND
	( uv_qty_mx.cmonth <= :arg_endcmon ) AND
	( uv_qty_mx.subid like :arg_subid_like ) AND
	( uv_qty_mx.postflag = :arg_postflag OR :arg_postflag = -1 )
	GROUP BY uv_qty_mx.dcflag,uv_qty_mx.cmonth


UNION ALL
	SELECT cw_Balance.YearMon as cmonth,
	NULL as price,
	case cw_Balance.ydamt when 0 then NULL else cw_Balance.ydamt END as damount,
	case cw_Balance.ycamt when 0 then NULL else cw_Balance.ycamt END as camount,
	case cw_Balance.ydebit when 0 then NULL else cw_Balance.ydebit END as debit,
	case cw_Balance.ycredit when 0 then NULL else cw_Balance.ycredit END as credit,
	'本年累计' as brief,
	NULL as credtype,
	NULL as credno,
	NULL as creddate,
	NULL as subaccsetid,
	cw_Balance.EDebit - cw_Balance.ecredit as balc,
	cw_Balance.BAmt + cw_Balance.dAmt - cw_Balance.cAmt as qtybalc,
	3 as dw_sort,
	0 as fuluno,
	cw_subject.dcflag as dcflag,
	0 as credid
	FROM cw_Balance,cw_subject
	WHERE ( cw_Balance.accsetid = :arg_accsetid ) AND
	( cw_Balance.YearMon >= :arg_firstcmon ) AND
	( cw_Balance.YearMon <= :arg_endcmon ) AND
	( cw_Balance.subid = :arg_subid ) and
	( cw_Balance.accsetid = cw_subject.accsetid ) and 
	( cw_Balance.subid = cw_subject.subid )
	
	

	"
  arguments=(("arg_accsetid", number), ("arg_subid", string), ("arg_firstcmon", number), ("arg_endcmon", number), ("arg_postflag", number), ("arg_subid_like", string), ("arg_rel", number))
 sort="cmonth A, dw_sort A, credtype A, credno A"
)
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="727" y="208" height="116" width="123" text="" )
text(band=header 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="0" alignment="0" border="2" x="590" y="208" height="116" width="128" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="9" y="208" height="116" width="325" text="" )
text(name=creddate_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="9" y="236" height="56" width="325" text="凭证日期" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="343" y="208" height="116" width="238" text="" )
text(name=cmonth_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="343" y="236" height="56" width="238" text="期间" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="859" y="208" height="116" width="594" text="" )
text(name=brief_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="859" y="236" height="56" width="594" text="摘要" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="1" border="2" x="1463" y="208" height="56" width="311" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="1783" y="208" height="56" width="251" text="借方" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="2043" y="208" height="56" width="375" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="1" border="2" x="2427" y="208" height="56" width="325" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="15793151" color="0" alignment="2" border="2" x="2761" y="208" height="56" width="293" text="贷方" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="0" border="2" x="3063" y="208" height="56" width="430" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="3502" y="208" height="116" width="123" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="3502" y="236" height="56" width="123" text="方向" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="3634" y="208" height="56" width="329" text="" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="3973" y="208" height="56" width="288" text="余额" )
text(name=credit_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="15793151" color="0" alignment="2" border="2" x="3063" y="268" height="56" width="430" text="金额" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="0" border="2" x="4270" y="208" height="56" width="416" text="" )
text(name=damount_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="1463" y="268" height="56" width="311" text="数量" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="1783" y="268" height="56" width="251" text="单价" )
text(name=debit_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="2043" y="268" height="56" width="375" text="金额" )
text(name=camount_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="15793151" color="0" alignment="2" border="2" x="2427" y="268" height="56" width="325" text="数量" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="15793151" color="0" alignment="2" border="2" x="2761" y="268" height="56" width="293" text="单价" )
text(name=qtybalc_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="3634" y="268" height="56" width="329" text="数量" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="3973" y="268" height="56" width="288" text="单价" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="4270" y="268" height="56" width="416" text="期末金额" )
text(name=credno_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="727" y="236" height="56" width="123" text="号" )
text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="590" y="236" height="56" width="128" text="字" )
column(name=cmonth band=detail id=1 x="343" y="4" height="68" width="238" color="0" border="0" alignment="2" 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=credno band=detail id=9 x="727" y="4" height="68" width="123" color="0" border="0" alignment="2" format="[general]" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=creddate band=detail id=10 x="9" y="4" height="68" width="325" color="0" border="0" alignment="2" format="yyyy-mm-dd" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=brief height.autosize=yes band=detail id=7 x="859" y="4" height="68" width="594" color="0" border="0" alignment="0" format="[general]" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=debit band=detail id=5 x="2043" y="4" height="68" width="375" color="0" border="0" alignment="1" format="#,##0.00" 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=camount band=detail id=4 x="2427" y="4" height="68" width="325" color="0" border="0" alignment="1" format="#,##0.00##" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=credit band=detail id=6 x="3063" y="4" height="68" width="430" color="0" border="0" alignment="1" format="#,##0.00" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
compute(name=dc band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="3502" y="4" height="68" width="123" format="[general]" expression="if( balc =0  ,'平',if( dcflag =1,if(balc >0 ,'借','贷'),if(balc>0 ,'贷','借'))  ) " alignment="2" border="0" crosstab.repeat=no )
column(name=qtybalc band=detail id=13 x="3634" y="4" height="68" width="329" color="0" border="0" alignment="1" format="#,##0.00##" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
compute(name=bprice band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" x="3973" y="4" height="68" width="288" format="[General]" expression=" round(balc / qtybalc ,2)" alignment="1" border="0" crosstab.repeat=no )
column(name=damount band=detail id=3 x="1463" y="4" height="68" width="311" color="0" border="0" alignment="1" format="#,##0.00##" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
compute(band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" x="1783" y="4" height="68" width="251" format="[general]" expression="round(debit / damount  ,2)" alignment="1" border="0" crosstab.repeat=no )
compute(band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" x="2761" y="4" height="68" width="293" format="[general]" expression="round( credit / camount ,2)" alignment="1" border="0" crosstab.repeat=no )
compute(name=dept_ebala band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="4270" y="4" height="68" width="416" format="#,##0.00" expression="abs(  balc )" alignment="1" border="0" crosstab.repeat=no )
column(name=credtype band=detail id=8 x="590" y="4" height="68" width="128" color="0" border="0" alignment="2" format="[general]" edit.autohscroll=no 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="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=bar 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="0" alignment="0" border="0" x="0" y="0" height="204" width="4727" text="" )
text(name=title band=foreground font.charset="134" font.face="黑体" font.family="0" font.height="-18" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="9" y="8" height="108" width="1774" text="数量金额明细帐" )
compute(band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="9" y="132" height="56" width="1015" format="[general]" expression="~"单位名称:~"+f_rst_Cropname()" alignment="0" border="0" crosstab.repeat=no )
text(name=month band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="1239" y="132" height="56" width="1102" text="" )
compute(band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" x="1806" y="60" height="56" width="1906" format="[general]" expression="'打印时间: '+string(today(),'yyyy-mm-dd hh:mm:ss')+ '   第 ' + string(page()) + ' 页/ 共 '+string(pageCount())+' 页'" alignment="1" border="0" crosstab.repeat=no )
text(name=mtrl band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="1" border="0" x="2368" y="132" height="56" width="1344" text="" )
htmltable(border="1" cellPadding="0" cellSpacing="0" generateCSS="no" noWrap="yes" )
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )