$PBExportHeader$dw_rp_money_scidsum.srd release 9; datawindow(units=0 timer_interval=60000 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 2 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 9 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 selected.mouse=no ) header(height=316 color="536870912" ) summary(height=80 color="536870912" ) footer(height=0 color="536870912" ) detail(height=84 color="536870912" ) table(column=(type=decimal(15) updatewhereclause=yes name=saleamt dbname="saleamt" ) column=(type=decimal(2) updatewhereclause=yes name=costamt dbname="costamt" ) column=(type=decimal(2) updatewhereclause=yes name=gpamt dbname="gpamt" ) column=(type=long updatewhereclause=yes name=u_outwaremx_scid dbname="u_outwaremx.scid" ) column=(type=char(30) updatewhereclause=yes name=u_scdef_scname dbname="u_scdef.scname" ) column=(type=decimal(2) updatewhereclause=yes name=item1 dbname="item1" ) column=(type=decimal(2) updatewhereclause=yes name=item2 dbname="item2" ) column=(type=decimal(2) updatewhereclause=yes name=item3 dbname="item3" ) column=(type=decimal(2) updatewhereclause=yes name=item4 dbname="item4" ) column=(type=decimal(2) updatewhereclause=yes name=item5 dbname="item5" ) column=(type=decimal(2) updatewhereclause=yes name=item6 dbname="item6" ) column=(type=decimal(2) updatewhereclause=yes name=item7 dbname="item7" ) column=(type=decimal(2) updatewhereclause=yes name=item8 dbname="item8" ) column=(type=decimal(2) updatewhereclause=yes name=item9 dbname="item9" ) column=(type=decimal(2) updatewhereclause=yes name=item10 dbname="item10" ) retrieve="SELECT SUM(ROUND(u_outwaremx.uqty * u_outwaremx.price, 2)) AS saleamt, SUM(u_outwaremx.costamt) AS costamt, SUM(ROUND(u_outwaremx.uqty * u_outwaremx.price, 2)) - SUM(u_outwaremx.costamt) as gpamt, u_outwaremx.scid, u_scdef.scname, 0.00 as item1, 0.00 as item2, 0.00 as item3, 0.00 as item4, 0.00 as item5, 0.00 as item6, 0.00 as item7, 0.00 as item8, 0.00 as item9, 0.00 as item10 FROM u_outwaremx INNER JOIN u_outware ON u_outwaremx.scid = u_outware.scid AND u_outwaremx.outwareid = u_outware.outwareid inner join u_scdef on u_outware.scid = u_scdef.scid WHERE (u_outware.flag = 1) and (u_outware.outdate between :arg_firstdate and :arg_enddate) and u_outware.scid in (:arg_scid) GROUP BY u_outwaremx.scid, u_scdef.scname " arguments=(("arg_firstdate", datetime),("arg_enddate", datetime),("arg_scid", numberlist)) ) column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="0" height="76" width="411" format="[general]" html.valueishtml="0" name=u_scdef_scname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=1 alignment="1" tabsequence=32766 border="0" color="33554432" x="430" y="0" height="76" width="430" format="#,##0.00" html.valueishtml="0" name=saleamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(costamt for all)"border="0" color="33554432" x="869" y="4" height="56" width="425" format="#,##0.00" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(gpamt for all)"border="0" color="33554432" x="1303" y="4" height="56" width="421" format="#,##0.00" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item1 for all)"border="0" color="33554432" x="1733" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0" name=compute_3 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item2 for all)"border="0" color="33554432" x="2171" y="4" height="56" width="416" format="#,##0.00" html.valueishtml="0" name=compute_4 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item3 for all)"border="0" color="33554432" x="2597" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0" name=compute_5 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item4 for all)"border="0" color="33554432" x="3035" y="4" height="56" width="421" format="#,##0.00" html.valueishtml="0" name=compute_6 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item5 for all)"border="0" color="33554432" x="3465" y="4" height="56" width="425" format="#,##0.00" html.valueishtml="0" name=compute_7 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item6 for all)"border="0" color="33554432" x="3899" y="4" height="56" width="416" format="#,##0.00" html.valueishtml="0" name=compute_8 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item7 for all)"border="0" color="33554432" x="4325" y="4" height="56" width="434" format="#,##0.00" html.valueishtml="0" name=compute_9 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item8 for all)"border="0" color="33554432" x="4768" y="4" height="56" width="416" format="#,##0.00" html.valueishtml="0" name=compute_10 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item9 for all)"border="0" color="33554432" x="5193" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0" name=compute_11 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(item10 for all)"border="0" color="33554432" x="5632" y="4" height="56" width="421" format="#,##0.00" html.valueishtml="0" name=compute_12 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=2 alignment="1" tabsequence=32766 border="0" color="33554432" x="869" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0" name=costamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=3 alignment="1" tabsequence=0 border="0" color="33554432" x="1307" y="0" height="76" width="416" format="#,##0.00" html.valueishtml="0" name=gpamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=6 alignment="1" tabsequence=0 border="0" color="33554432" x="1737" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0" name=item1 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=7 alignment="1" tabsequence=0 border="0" color="33554432" x="2176" y="0" height="76" width="411" format="#,##0.00" html.valueishtml="0" name=item2 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=8 alignment="1" tabsequence=0 border="0" color="33554432" x="2601" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0" name=item3 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=9 alignment="1" tabsequence=0 border="0" color="33554432" x="3040" y="0" height="76" width="416" format="#,##0.00" html.valueishtml="0" name=item4 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=10 alignment="1" tabsequence=0 border="0" color="33554432" x="3470" y="0" height="76" width="421" format="#,##0.00" html.valueishtml="0" name=item5 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=11 alignment="1" tabsequence=0 border="0" color="33554432" x="3904" y="0" height="76" width="411" format="#,##0.00" html.valueishtml="0" name=item6 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=12 alignment="1" tabsequence=0 border="0" color="33554432" x="4329" y="0" height="76" width="430" format="#,##0.00" html.valueishtml="0" name=item7 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=13 alignment="1" tabsequence=0 border="0" color="33554432" x="4773" y="0" height="76" width="411" format="#,##0.00" html.valueishtml="0" name=item8 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=14 alignment="1" tabsequence=0 border="0" color="33554432" x="5198" y="0" height="76" width="425" format="#,##0.00" html.valueishtml="0" name=item9 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=15 alignment="1" tabsequence=0 border="0" color="33554432" x="5637" y="0" height="76" width="416" format="#,##0.00" html.valueishtml="0" name=item10 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) compute(band=summary alignment="1" expression="sum(saleamt for all)"border="0" color="33554432" x="430" y="4" height="56" width="430" format="#,##0.00" html.valueishtml="0" name=compute_13 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="分部" border="2" color="33554432" x="9" y="260" height="56" width="411" html.valueishtml="0" name=u_scdef_scname_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="销售金额" border="2" color="33554432" x="430" y="260" height="56" width="430" html.valueishtml="0" name=saleamt_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="成本金额" border="2" color="33554432" x="869" y="260" height="56" width="425" html.valueishtml="0" name=costamt_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="毛利金额" border="2" color="33554432" x="1303" y="260" height="56" width="421" html.valueishtml="0" name=gpamt_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item1" border="2" color="33554432" x="1733" y="260" height="56" width="430" html.valueishtml="0" name=item1_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item2" border="2" color="33554432" x="2171" y="260" height="56" width="416" html.valueishtml="0" name=item2_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item3" border="2" color="33554432" x="2597" y="260" height="56" width="430" html.valueishtml="0" name=item3_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item4" border="2" color="33554432" x="3035" y="260" height="56" width="421" html.valueishtml="0" name=item4_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item5" border="2" color="33554432" x="3465" y="260" height="56" width="425" html.valueishtml="0" name=item5_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item6" border="2" color="33554432" x="3899" y="260" height="56" width="416" html.valueishtml="0" name=item6_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item7" border="2" color="33554432" x="4325" y="260" height="56" width="434" html.valueishtml="0" name=item7_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item8" border="2" color="33554432" x="4768" y="260" height="56" width="416" html.valueishtml="0" name=item8_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item9" border="2" color="33554432" x="5193" y="260" height="56" width="430" html.valueishtml="0" name=item9_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) text(band=header alignment="2" text="Item10" border="2" color="33554432" x="5632" y="260" height="56" width="421" html.valueishtml="0" name=item10_t visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) htmltable(border="1" ) htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" ) export.xml(usetemplate="" headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 template=(comment="" encoding="gb2312" name="e" xml="accountid")) import.xml(usetemplate="" ) export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )