The LOTUS output option displays the label in a Lotus 1-2-3 format file.
Syntax:
LBLPRINT labelname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION LOTUS
The following OPTION parameters are available to customize the output:
Parameter |
Value |
Description |
FILENAME |
value |
Specifies the full path and filename. If no path is defined, output will be saved in the current working directory. |
SHOW_CANCEL_DIALOG |
ON (default) OFF |
Specifies whether to suppress cancel dialog box during the print process. |
COLUMN_SPACING |
value |
Specifies the column spacing between data. Use -1 for auto-spacing. |
ROW_SPACING |
value |
Specifies the row spacing between data. Use -1 for auto-spacing. |
AUTO_FORMAT_CELLS |
ON OFF |
Specifies if the format of the rendered text (Integer, Double etc) is detected automatically. Otherwise the content is just inserted as text without any format considerations. |
SCALEX |
value |
Scaling factor for the width of the exported page. Use 1 for actual width. |
SCALEY |
value |
Scaling factor for the height of the exported page. Use 1 for actual height. |
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.
Example:
--To print a label as a Lotus file
LBLPRINT CustomerLabels WHERE CustID = 128 +
OPTION LOTUS +
|FILENAME CustLab128.WK1 +
|SHOW_CANCEL_DIALOG ON +
|OPEN OFF +
|ROW_SPACING 1
