ds_ow_inwarewfjg_sumqty.srd 5.0 KB

12345678910111213141516171819202122232425262728293031323334
  1. $PBExportHeader$ds_ow_inwarewfjg_sumqty.srd
  2. release 9;
  3. datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 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 )
  4. header(height=168 color="536870912" )
  5. summary(height=0 color="536870912" )
  6. footer(height=0 color="536870912" )
  7. detail(height=104 color="536870912" )
  8. table(column=(type=long updatewhereclause=yes name=ow_wfjgmx_in_aft_scid dbname="ow_wfjgmx_in_aft.scid" )
  9. column=(type=long updatewhereclause=yes name=ow_wfjgmx_in_aft_relid dbname="ow_wfjgmx_in_aft.relid" )
  10. column=(type=decimal(10) updatewhereclause=yes name=sumqty dbname="sumqty" )
  11. column=(type=long updatewhereclause=yes name=ow_wfjgmx_in_aft_relprintid dbname="ow_wfjgmx_in_aft.relprintid" )
  12. retrieve="SELECT ow_wfjgmx_in_aft.scid, ow_wfjgmx_in_aft.relid, SUM(ow_wfjgmx_in_aft.qty)
  13. AS sumqty, ow_wfjgmx_in_aft.relprintid
  14. FROM ow_wfjgmx_in_aft INNER JOIN
  15. ow_wfjg_in ON ow_wfjgmx_in_aft.scid = ow_wfjg_in.scid AND
  16. ow_wfjgmx_in_aft.inwareid = ow_wfjg_in.inwareid
  17. WHERE (ow_wfjgmx_in_aft.relid > 0) AND (ow_wfjg_in.flag = 1)
  18. GROUP BY ow_wfjgmx_in_aft.scid, ow_wfjgmx_in_aft.relid, ow_wfjgmx_in_aft.relprintid" )
  19. text(band=header alignment="2" text="Ow Wfjgmx In Aft
  20. Scid" border="0" color="33554432" x="9" y="8" height="152" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_scid_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  21. text(band=header alignment="2" text="Ow Wfjgmx In Aft
  22. Relid" border="0" color="33554432" x="549" y="8" height="152" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_relid_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  23. text(band=header alignment="2" text="Sumqty" border="0" color="33554432" x="1088" y="8" height="76" width="658" html.valueishtml="0" name=sumqty_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  24. text(band=header alignment="2" text="Ow Wfjgmx In Aft
  25. Relprintid" border="0" color="33554432" x="1755" y="8" height="152" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_relprintid_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  26. column(band=detail id=1 alignment="1" tabsequence=32766 border="0" color="33554432" x="9" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_scid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  27. column(band=detail id=2 alignment="1" tabsequence=32766 border="0" color="33554432" x="549" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_relid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  28. column(band=detail id=3 alignment="1" tabsequence=32766 border="0" color="33554432" x="1088" y="8" height="88" width="658" format="[general]" html.valueishtml="0" name=sumqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  29. column(band=detail id=4 alignment="1" tabsequence=32766 border="0" color="33554432" x="1755" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_relprintid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  30. htmltable(border="1" )
  31. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  32. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  33. import.xml()
  34. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )