Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > P > PRINT

PNG

Scroll Prev Top Next More

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.

EMAIL

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