dw_rp_brief.srd 7.2 KB

12345678910111213141516171819202122232425262728293031323334
  1. $PBExportHeader$dw_rp_brief.srd
  2. $PBExportComments$By Kivens.Jiang(kivens@21cn.com)
  3. release 9;
  4. datawindow ( units=0 timer_interval=0 color=16777215 processing=1 print.documentname="" print.orientation=2 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)
  5. header(height=224 color="536870912" )
  6. summary(height=0 color="536870912" )
  7. footer(height=0 color="536870912" )
  8. detail(height=84 color="536870912" )
  9. table(column=(type=char(32) updatewhereclause=yes name=cw_brieftype_typename dbname="cw_brieftype.typename" )
  10. column=(type=char(50) updatewhereclause=yes name=cw_brief_briefname dbname="cw_brief.briefname" )
  11. column=(type=char(30) updatewhereclause=yes name=cw_brief_briefcode dbname="cw_brief.briefcode" )
  12. column=(type=char(18) updatewhereclause=yes name=cw_brief_dftsubid dbname="cw_brief.dftsubid" )
  13. column=(type=char(60) updatewhereclause=yes name=cw_subject_name dbname="cw_subject.name" )
  14. retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"cw_brief~" ) TABLE(NAME=~"cw_brieftype~" ) TABLE(NAME=~"cw_subject~" ) COLUMN(NAME=~"cw_brieftype.typename~") COLUMN(NAME=~"cw_brief.briefname~") COLUMN(NAME=~"cw_brief.briefcode~") COLUMN(NAME=~"cw_brief.dftsubid~") COLUMN(NAME=~"cw_subject.name~") JOIN (LEFT=~"cw_brief.accsetid~" OP =~"=~"RIGHT=~"cw_brieftype.accsetid~" OUTER1 =~"cw_brief.accsetid~" ) JOIN (LEFT=~"cw_brief.brieftypeid~" OP =~"=~"RIGHT=~"cw_brieftype.brieftypeid~" OUTER1 =~"cw_brief.brieftypeid~" ) JOIN (LEFT=~"cw_brief.accsetid~" OP =~"=~"RIGHT=~"cw_subject.accsetid~" OUTER1 =~"cw_brief.accsetid~" ) JOIN (LEFT=~"cw_brief.dftsubid~" OP =~"=~"RIGHT=~"cw_subject.subid~" OUTER1 =~"cw_brief.dftsubid~" )WHERE( EXP1 =~"cw_brief.accsetid~" OP =~"=~" EXP2 =~":arg_accsetid~" ) ) ARG(NAME = ~"arg_accsetid~" TYPE = number) "
  15. arguments=(("arg_accsetid", number))
  16. sort="cw_brieftype_typename A, cw_brief_briefcode A"
  17. )
  18. text(name=cw_brieftype_typename_t band=header 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="2" border="2" x="9" y="164" height="60" width="297" text="类别" )
  19. text(name=cw_brief_briefcode_t band=header 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="2" border="2" x="315" y="164" height="60" width="224" text="代号" )
  20. text(name=cw_brief_briefname_t band=header 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="2" border="2" x="549" y="164" height="60" width="1518" text="凭证摘要" )
  21. text(name=cw_brief_dftsubid_t band=header 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="2" border="2" x="2075" y="164" height="60" width="453" text="默认科目" )
  22. text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" alignment="2" border="2" x="2537" y="164" height="60" width="809" text="科目名称" )
  23. column(name=cw_brieftype_typename tag="摘要类别" band=detail id=1 x="9" y="8" height="68" width="297" color="0" border="0" alignment="0" 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=32 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="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  24. column(name=cw_brief_briefcode band=detail id=3 x="315" y="8" height="68" width="224" color="0" border="0" alignment="0" 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=30 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="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  25. column(name=cw_brief_briefname tag="凭证摘要" band=detail id=2 x="549" y="8" height="68" width="1518" color="0" border="0" alignment="0" 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=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="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  26. column(name=cw_brief_dftsubid band=detail id=4 x="2075" y="8" height="68" width="453" color="0" border="0" alignment="0" 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=18 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="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  27. column(name=cw_subject_name band=detail id=5 x="2537" y="8" height="68" width="809" 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="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  28. text(band=foreground font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="0" border="0" x="0" y="0" height="160" width="3378" text="" )
  29. text(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="14" y="20" height="108" width="1413" text="凭证摘要" )
  30. htmltable(border="1" cellPadding="0" cellSpacing="0" generateCSS="no" noWrap="yes" )
  31. htmlgen()
  32. export.xml(metadatatype=0 savemetadata=0 )
  33. import.xml()
  34. export.pdf(method=0 )