The PNG output option displays the report in a Portable Network Graphics image file.
Syntax:
PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION PNG
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. |
TITLE |
value |
Specifies the title of the report |
SUBJECT |
value |
Specifies the subject of the report |
AUTHOR |
value |
Specifies the author of the report |
KEYWORDS |
value |
Stores the list of keywords used in the report |
INCLUDE_TEXT |
ON OFF |
Specifies whether text on the report should be included in the exported file. |
INCLUDE_SHAPES |
ON OFF |
Specifies whether shapes on the report should be included in the exported file. |
INCLUDE_IMAGES |
ON OFF |
Specifies whether images on the report should be included in the exported file. |
IMAGE_DPI |
value |
Specifies the depth of image as "dots per inch" to enhance the image. By increasing this value, the file size will increase. An example would be 200. The Default Value is -1. |
PIXELFORMAT |
1 : 1bit 4 : 4bit 8 : 8bit 15 : 15bit 16 : 16bit 24 : 24bit 32 : 32bit |
Specifies the pixel format of the file (bits/pixel). |
COLOR_TYPE |
GRAYSCALE RGB (default) RGB_ALPHA GRAY_ALPHA |
Specifies the color type of the image |
PIXEL_DIMENSIONS |
ON OFF |
Enables the ability to set PNG pixel dimension information |
UNIT_SPECIFIER |
NONE METER |
Specifies the units for setting the pixel dimension information. PIXEL_DIMENSIONS must be set ON in order to use the parameter. With NONE, X_PIXELS_PER_UNIT and Y_PIXELS_PER_UNIT defines pixel aspect ratio only, and the actual size of the pixels remains unspecified. Using METER the actual size of the pixels is specified |
X_PIXELS_PER_UNIT |
value |
Specifies the number of pixels per unit in the horizontal direction. PIXEL_DIMENSIONS must be set ON in order to use the parameter. Default: 1 |
Y_PIXELS_PER_UNIT |
value |
Specifies the number of pixels per unit in the vertical direction. PIXEL_DIMENSIONS must be set ON in order to use the parameter. Default: 1 |
TRANSPARENCY |
ON OFF |
Sets the fields related to transparency of the output |
IMAGE_ALPHA |
0 - 100 |
Specifies a percentage of transparency for the output. This is applicable only when TRANSPARENCY is ON and COLOR_TYPE is either RGB_ALPHA or GRAY_ALPHA. If IMAGE_ALPHA is 0, then the image is completely transparent. If IMAGE_ALPHA is 100, then the image is completely opaque. Default: 0 |
TRANSPARENT_COLOR |
value |
Specifies the color that is transparent. This is applicable only when TRANSPARENCY is ON and COLOR_TYPE is either RGB or GRAYSCALE. |
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 PNG file
PRINT Invoice WHERE TransID = 1068 +
OPTION PNG +
|FILENAME Invoice1068.PNG +
|SHOW_CANCEL_DIALOG OFF +
|INCLUDE_SHAPES OFF +
|INCLUDE_IMAGES ON +
|OPEN ON
