Previous topic Next topic
DO REPORT
Help > Commands >

/////////////////////////////////////////////////////////////////////
// DO REPORT
/////////////////////////////////////////////////////////////////////

#xcommand DO REPORT ;
      TITLE <ctitle> ;
      HEADERS <aheaders1>, <aheaders2> ;
      FIELDS <a> ;
      WIDTHS <awidths> ;
      [ TOTALS <ato> ] ;
      [ NFORMATS <aformats> ] ;
      WORKAREA <calias> ;
      [ LPP <nlpp> ] ;
      [ CPL <ncpl> ] ;
      [ LMARGIN <nllmargin> ] ;
      [ PAPERSIZE <npapersize> ] ;
      [ <lnoprop: NOFIXED> ] ;
      [ <ldos: DOSMODE> ] ;
      [ <lpreview: PREVIEW> ] ;
      [ <lselect: SELECT> ] ;
      [ IMAGE <cgraphic> AT <nfi>, <nci> TO <nff>, <ncf> ] ;
      [ <lmul: MULTIPLE> ] ;
      [ GROUPED BY <cgrpby> ] ;
      [ HEADRGRP <chdrgrp> ] ;
      [ <llandscape: LANDSCAPE> ] ;
      [ <lgroupeject: GROUPEJECT> ] ;
      [ HEADING <cheader> ] ;
   => ;
      EasyReport( <ctitle>, <aheaders1>, <aheaders2>, <a>, <awidths>, <ato>, ;
            <nlpp>, <.ldos.>, <.lpreview.>, <cgraphic>, <nfi>, <nci>, <nff>, ;
            <ncf>, <.lmul.>, <"cgrpby">, <chdrgrp>, <.llandscape.>, <ncpl>, ;
            <.lselect.>, <(calias)>, <nllmargin>, <aformats>, <npapersize>, ;
            <cheader>, <.lnoprop.>, <.lgroupeject.> )


/////////////////////////////////////////////////////////////////////
// REPORTFORMWIN
/////////////////////////////////////////////////////////////////////

#command REPORTFORMWIN <frm> ;
      [ HEADING <head> ] ;
      [ <plain:PLAIN> ] ;
      [ <noej:NOEJECT> ] ;
      [ <sum:SUMMARY> ] ;
      [ <nocon:NOCONSOLE> ] ;
      [ <prn:TO PRINTER> ] [ TO FILE <(f)> ] ;
      [ FOR <for> ] ;
      [ WHILE <while> ] ;
      [ NEXT <next> ] ;
      [ RECORD <rec> ] ;
      [ <rest:REST> ] ;
      [ ALL ] ;
   => ;
      __ReportFormwin( <(frm)>, <.prn.>, <(f)>, <.nocon.>, <{for}>, <{while}>, ;
            <next>, <rec>, <.rest.>, <.plain.>, <head>, <.noej.>, <.sum.> )


/////////////////////////////////////////////////////////////////////
// DO REPORT FORM
/////////////////////////////////////////////////////////////////////

#xcommand DO REPORT FORM <cfilerep> ;
      [ HEADING <cheading> ] ;
   => ;
      ExtReport( <"cfilerep">, <cheading> )

Paper size:

      DMPAPER_FIRST                          DMPAPER_LETTER
      DMPAPER_LETTER                         Letter 8 1/2 x 11 in
      DMPAPER_LETTERSMALL                    Letter Small 8 1/2 x 11 in
      DMPAPER_TABLOID                        Tabloid 11 x 17 in
      DMPAPER_LEDGER                         Ledger 17 x 11 in
      DMPAPER_LEGAL                          Legal 8 1/2 x 14 in
      DMPAPER_STATEMENT                      Statement 5 1/2 x 8 1/2 in
      DMPAPER_EXECUTIVE                      Executive 7 1/4 x 10 1/2 in
      DMPAPER_A3                             A3 297 x 420 mm )
      DMPAPER_A4                             A4 210 x 297 mm
      DMPAPER_A4SMALL                        A4 Small 210 x 297 mm
      DMPAPER_A5                             A5 148 x 210 mm
      DMPAPER_B4                             B4 (JIS) 250 x 354
      DMPAPER_B5                             B5 (JIS) 182 x 257 mm
      DMPAPER_FOLIO                          Folio 8 1/2 x 13 in
      DMPAPER_QUARTO                         Quarto 215 x 275 mm
      DMPAPER_10X14                          10x14 in
      DMPAPER_11X17                          11x17 in
      DMPAPER_NOTE                           Note 8 1/2 x 11 in
      DMPAPER_ENV_9                          Envelope #9 3 7/8 x 8 7/8
      DMPAPER_ENV_10                         Envelope #10 4 1/8 x 9 1/2
      DMPAPER_ENV_11                         Envelope #11 4 1/2 x 10 3/8
      DMPAPER_ENV_12                         Envelope #12 4 \276 x 11
      DMPAPER_ENV_14                         Envelope #14 5 x 11 1/2
      DMPAPER_CSHEET                         C size sheet
      DMPAPER_DSHEET                         D size sheet
      DMPAPER_ESHEET                         E size sheet
      DMPAPER_ENV_DL                         Envelope DL 110 x 220mm
      DMPAPER_ENV_C5                         Envelope C5 162 x 229 mm
      DMPAPER_ENV_C3                         Envelope C3 324 x 458 mm
      DMPAPER_ENV_C4                         Envelope C4 229 x 324 mm
      DMPAPER_ENV_C6                         Envelope C6 114 x 162 mm
      DMPAPER_ENV_C65                        Envelope C65 114 x 229 mm
      DMPAPER_ENV_B4                         Envelope B4 250 x 353 mm
      DMPAPER_ENV_B5                         Envelope B5 176 x 250 mm
      DMPAPER_ENV_B6                         Envelope B6 176 x 125 mm
      DMPAPER_ENV_ITALY                      Envelope 110 x 230 mm
      DMPAPER_ENV_MONARCH                    Envelope Monarch 3.875 x 7.5 in
      DMPAPER_ENV_PERSONAL                   6 3/4 Envelope 3 5/8 x 6 1/2 in
      DMPAPER_FANFOLD_US                     US Std Fanfold 14 7/8 x 11 in
      DMPAPER_FANFOLD_STD_GERMAN             German Std Fanfold 8 1/2 x 12 in
      DMPAPER_FANFOLD_LGL_GERMAN             German Legal Fanfold 8 1/2 x 13 in
      DMPAPER_ISO_B4                         B4 (ISO) 250 x 353 mm
      DMPAPER_JAPANESE_POSTCARD              Japanese Postcard 100 x 148 mm
      DMPAPER_9X11                           9 x 11 in
      DMPAPER_10X11                          10 x 11 in
      DMPAPER_15X11                          15 x 11 in
      DMPAPER_ENV_INVITE                     Envelope Invite 220 x 220 mm
      DMPAPER_RESERVED_48                    RESERVED--DO NOT USE
      DMPAPER_RESERVED_49                    RESERVED--DO NOT USE
      DMPAPER_LETTER_EXTRA                   Letter Extra 9 \275 x 12 in
      DMPAPER_LEGAL_EXTRA                    Legal Extra 9 \275 x 15 in
      DMPAPER_TABLOID_EXTRA                  Tabloid Extra 11.69 x 18 in
      DMPAPER_A4_EXTRA                       A4 Extra 9.27 x 12.69 in
      DMPAPER_LETTER_TRANSVERSE              Letter Transverse 8 \275 x 11 in
      DMPAPER_A4_TRANSVERSE                  A4 Transverse 210 x 297 mm
      DMPAPER_LETTER_EXTRA_TRANSVERSE        Letter Extra Transverse 9\275 x 12 in
      DMPAPER_A_PLUS                         SuperA/SuperA/A4 227 x 356 mm
      DMPAPER_B_PLUS                         SuperB/SuperB/A3 305 x 487 mm
      DMPAPER_LETTER_PLUS                    Letter Plus 8.5 x 12.69 in
      DMPAPER_A4_PLUS                        A4 Plus 210 x 330 mm
      DMPAPER_A5_TRANSVERSE                  A5 Transverse 148 x 210 mm
      DMPAPER_B5_TRANSVERSE                  B5 (JIS) Transverse 182 x 257 mm
      DMPAPER_A3_EXTRA                       A3 Extra 322 x 445 mm
      DMPAPER_A5_EXTRA                       A5 Extra 174 x 235 mm
      DMPAPER_B5_EXTRA                       B5 (ISO) Extra 201 x 276 mm
      DMPAPER_A2                             A2 420 x 594 mm
      DMPAPER_A3_TRANSVERSE                  A3 Transverse 297 x 420 mm
      DMPAPER_A3_EXTRA_TRANSVERSE            A3 Extra Transverse 322 x 445 mm
      DMPAPER_DBL_JAPANESE_POSTCARD          Jap. Double Postcard 200 x 148 mm
      DMPAPER_A6                             A6 105 x 148 mm
      DMPAPER_JENV_KAKU2                     Japanese Envelope Kaku #2
      DMPAPER_JENV_KAKU3                     Japanese Envelope Kaku #3
      DMPAPER_JENV_CHOU3                     Japanese Envelope Chou #3
      DMPAPER_JENV_CHOU4                     Japanese Envelope Chou #4
      DMPAPER_LETTER_ROTATED                 Letter Rotated 11 x 8 1/2 11 in
      DMPAPER_A3_ROTATED                     A3 Rotated 420 x 297 mm
      DMPAPER_A4_ROTATED                     A4 Rotated 297 x 210 mm
      DMPAPER_A5_ROTATED                     A5 Rotated 210 x 148 mm
      DMPAPER_B4_JIS_ROTATED                 B4 (JIS) Rotated 364 x 257 mm
      DMPAPER_B5_JIS_ROTATED                 B5 (JIS) Rotated 257 x 182 mm
      DMPAPER_JAPANESE_POSTCARD_ROTATED      Jap. Postcard Rotated 148 x 100 mm
      DMPAPER_DBL_JAPANESE_POSTCARD_ROTATED  Double Jap. Postcard Rotated 148 x 200 mm
      DMPAPER_A6_ROTATED                     A6 Rotated 148 x 105 mm
      DMPAPER_JENV_KAKU2_ROTATED             Japanese Envelope Kaku #2 Rotated
      DMPAPER_JENV_KAKU3_ROTATED             Japanese Envelope Kaku #3 Rotated
      DMPAPER_JENV_CHOU3_ROTATED             Japanese Envelope Chou #3 Rotated
      DMPAPER_JENV_CHOU4_ROTATED             Japanese Envelope Chou #4 Rotated
      DMPAPER_B6_JIS                         B6 (JIS) 128 x 182 mm
      DMPAPER_B6_JIS_ROTATED                 B6 (JIS) Rotated 182 x 128 mm
      DMPAPER_12X11                          12 x 11 in
      DMPAPER_JENV_YOU4                      Japanese Envelope You #4
      DMPAPER_JENV_YOU4_ROTATED              Japanese Envelope You #4 Rotated
      DMPAPER_P16K                           PRC 16K 146 x 215 mm
      DMPAPER_P32K                           RC 32K 97 x 151 mm
      DMPAPER_P32KBIG                        PRC 32K(Big) 97 x 151 mm
      DMPAPER_PENV_1                         PRC Envelope #1 102 x 165 mm
      DMPAPER_PENV_2                         PRC Envelope #2 102 x 176 mm
      DMPAPER_PENV_3                         PRC Envelope #3 125 x 176 mm
      DMPAPER_PENV_4                         Envelope #4 110 x 208 mm
      DMPAPER_PENV_5                         PRC Envelope #5 110 x 220 mm
      DMPAPER_PENV_6                         PRC Envelope #6 120 x 230 mm
      DMPAPER_PENV_7                         PRC Envelope #7 160 x 230 mm
      DMPAPER_PENV_8                         PRC Envelope #8 120 x 309 mm
      DMPAPER_PENV_9                         PRC Envelope #9 229 x 324 mm
      DMPAPER_PENV_10                        Envelope #10 324 x 458 mm
      DMPAPER_P16K_ROTATED                   PRC 16K Rotated
      DMPAPER_P32K_ROTATED                   PRC 32K Rotated
      DMPAPER_P32KBIG_ROTATED                PRC 32K(Big) Rotated
      DMPAPER_PENV_1_ROTATED                 PRC Envelope #1 Rotated 165 x 102 mm
      DMPAPER_PENV_2_ROTATED                 PRC Envelope #2 Rotated 176 x 102 mm
      DMPAPER_PENV_3_ROTATED                 PRC Envelope #3 Rotated 176 x 125 mm
      DMPAPER_PENV_4_ROTATED                 PRC Envelope #4 Rotated 208 x 110 mm
      DMPAPER_PENV_5_ROTATED                 PRC Envelope #5 Rotated 220 x 110 mm
      DMPAPER_PENV_6_ROTATED                 PRC Envelope #6 Rotated 230 x 120 mm
      DMPAPER_PENV_7_ROTATED                 PRC Envelope #7 Rotated 230 x 160 mm
      DMPAPER_PENV_8_ROTATED                 PRC Envelope #8 Rotated 309 x 120 mm
      DMPAPER_PENV_9_ROTATED                 PRC Envelope #9 Rotated 324 x 229 mm
      DMPAPER_PENV_10_ROTATED                PRC Envelope #10 Rotated 458 x 324 mm
      DMPAPER_USER                           User defined