The JPG output option displays the report in a JPEG image file.
Syntax:
PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION JPG
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. |
SHOW_CANCEL_DIALOG |
ON (default) OFF |
Specifies whether to suppress cancel dialog box during the print process. |
BACKGROUND_COLOR |
value |
Indicates the color to be used as background color of all pages of report. |
BACKGROUND_TYPE |
TILE TOPLEFT TOPCENTER TOPRIGHT CENTERLEFT CENTER CENTERRIGHT BOTTOMLEFT BOTTOMCENTER BOTTOMRIGHT |
Specifies the way background image has to be displayed in the BMP file. |
BACKGROUND_FILE |
value |
Stores the image file name that is to be used as background image of all pages of report. |
GRAYSCALE |
ON OFF |
Determines whether the image output of a JPEG image is black and white, or color. Use GRAYSCALE for reading in and writing out, that is, for decompressing and compressing, a JPEG image. This property affects how the image is displayed.
GRAYSCALE is used for speed in output optimization. When GRAYSCALE is set to ON, the color is separated from luminosity. Color takes the most time to decompress, so for previewing the image, GRAYSCALE can be set to True for speed. The output then contains 255 shades of gray.
|
PIXELFORMAT |
1 : 1bit 4 : 4bit 8 : 8bit 15 : 15bit 16 : 16bit 24 : 24bit 32 : 32bit |
Specifies the pixel format of the file (bits/pixel). |
PROGRESSIVE_ENCODING |
ON OFF |
Determines whether an image can be progressively displayed when it is decompressed. |
QUALITY |
1-100 |
Determines the closeness of the saved, JPEG image to the original. As a side effect it also matter to the size of the saved file. Setting a larger value improves image quality but also increases file size; a smaller value decreases image quality and also reduces file size. Alter it according to the need. |
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 Invoice as JPG file
PRINT Invoice WHERE TransID = 1068 +
OPTION JPG +
|FILENAME Invoice1068.JPG +
|SHOW_CANCEL_DIALOG OFF +
|BACKGROUND_COLOR WHITE +
|GRAYSCALE OFF +
|PIXELFORMAT 32 +
|QUALITY 100 +
|SCALEX 1 +
|SCALE 1 +
|OPEN ON