The ETXT output option displays the report in a report emulation text file, which prints the report as plain readable text including all bands, such as Report Header, Page Header, Break Headers, Break Footers, Page Footers and Report Footers, if exist.
Syntax:
PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION ETXT
The following OPTION parameters are available to customize the output:
Parameter |
Value |
Description |
FILENAME |
value |
Specifies the full path and file name. If no path is defined, output will be saved in the current working directory. |
APPEND |
Appends the report data to the specified FILENAME value. |
|
SHOW_CANCEL_DIALOG |
ON (default) OFF |
Specifies whether to suppress cancel dialog box during the print process. |
OPEN |
ON OFF |
Specifies whether the report should be opened after it is generated. |
PAGE_SETTINGS |
ALL FIRST LAST PAGE_LIST |
Specifies the option to print All, First, Last or a given number of pages. When PAGE_LIST is set as the value for PAGE_SETTINGS, the PAGE_LIST_VALUES parameter must be used with option in order to specify the page list. |
PAGE_LIST_VALUES |
value |
Specifies the values for number of pages, such as, 3,5,8 or 3,8 or 3, or 1-3,8 or 3,5,9-15. This option must be used with the PAGE_SETTINGS parameter when PAGE_LIST is specified. |
PAGE_STYLE_SETTINGS |
ALL FIRST LAST Page List e.g. 1,4-6,10-12,20 |
Determines the pages in which the Page Style will appear on. |
MARGIN_LEFT |
value |
Specifies the horizontal position on the page where printing should begin. All report component positions are relative to the margin. In other words, if the MARGIN_LEFT parameter is set to 0.25 inches and you place a report component in a band and set the component's "left" parameter to 0, then that component will print 0.25 inches from the edge of page (or at the left margin). |
MARGIN_TOP |
value |
Specifies the vertical position on the page where printing should begin. All report component positions are relative to the margin. In other words, if the MARGIN_TOP parameter is set to 0.25 inches and you place a report component in a band and set the component's "top" parameter to 0, then that component will print 0.25 inches from the edge of page (or at the top margin). |
MARGIN_RIGHT |
value |
Specifies the horizontal position on the page where printing should stop. All report component positions are relative to the margin. |
MARGIN_BOTTOM |
value |
Specifies the vertical position on the page where printing should stop. All report component positions are relative to the margin. |
ON OFF |
Specifies the report output (defined as FILENAME filename.ext ) to be sent via e-mail as an attachment. See additional options when EMAIL value is set to ON. EMAIL SET ON |
Note: Each additional OPTION parameter must be separated by the pipe | symbol.
Examples:
--To print columnar report as Emulation Text - ETXT file
PRINT ColumnarReport +
OPTION ETXT +
|FILENAME ColumnarReport.TXT +
|SHOW_CANCEL_DIALOG OFF +
|OPEN ON
--Prints the BonusText report and appends the output to the BonusText.txt file
PRINT BonusText +
OPTION ETXT +
|FILENAME BonusText.txt +
|APPEND
