Print.property

Description

Properties that control the printing of a DataWindow.

Applies to

DataWindows

Syntax

Describe and Modify argument:

"DataWindow.Print.property { = value }"

SyntaxFromSql:

DataWindow ( Print.property = value )

Parameter	Description
property	A property for printing. Properties and their settings are listed in the table below.
value	The value to be assigned to the property. Value cannot be a DataWindow expression.

Property for Print	Value
Background	Whether the background settings of the DataWindow and controls display on the printed report. Values are: Yes – Display background on report. This feature is not supported when you use a picture as the DataWindow background. No – (Default) Do not display background on report. Painter: Print Shows Background option.
Buttons	Whether buttons display on the printed output. Values are: Yes – Buttons are displayed. No – Buttons are not displayed. Painter: Display Buttons – Print.
CanUseDefault Printer	Whether a report can be printed on the default system printer if the printer specified by the PrinterName property is not valid. Painter: Can Use Default Printer option.
ClipText	Whether the text of a static text field on a printed page is clipped to the dimensions of the text field when the text field has no visible border setting. Values are: Yes – The printed text does not overrun the text field. No – (Default) The entire text can overrun the text field. Text is automatically clipped for text fields with visible border settings even if this property is not set. Painter: Clip Text option.
Collate	Whether printing is collated. Note that collating is usually slower since the print is repeated to produce collated sets. Values are: Yes – (Default) Collate the pages of the print job. No – Do not collate. Painter: Collate Copies option.
Color	An integer indicating whether the printed output will be color or monochrome. Values are: 1 – Color 2 – Monochrome The user can specify the value in the system’s Print dialog box if the printer driver supports it.
Columns	An integer specifying the number of newspaper-style columns the DataWindow will print on a page. For purposes of page fitting, the whole DataWindow is a single column. The default is 1. Painter: Newspaper Columns Across option.
Columns.Width	An integer specifying the width of the newspaper-style columns in the units specified for the DataWindow. Painter: Newspaper Columns Width option.
Copies	An integer indicating the number of copies to be printed. The user can also specify this value in the system’s Print Setup dialog box if the printer driver supports it. If you use both the Print.Copies property and the Print Setup dialog box to indicate that multiple copies should be printed, the total number of copies printed is the product of the two values.
CustomPage.Length	A long indicating the desired length of a custom paper size for printing. Use this property in conjunction with Print.CustomPage.Width and with Paper.Size set to 256.
CustomPage.Width	A long indicating the desired width of a custom paper size for printing. Use this property in conjunction with Print.CustomPage.Length and with Paper.Size set to 256.
DocumentName	A string containing the name that will display in the print queue when the user sends the contents of the DataWindow object to the printer. Painter: Document Name option.
Duplex	An integer indicating duplex or double-sided printing for printers capable of duplex printing. Values are: 0 – Default 1 – Normal (nonduplex) printing 2 – Short-edge binding (the long edge of the page is horizontal) 3 – Long-edge binding (the long edge of the page is vertical) The user can specify the value in the system’s Print dialog box if the printer driver supports it.
Filename	A string containing the name of the file to which you want to print the report. An empty string means send to the printer. Painter: Cannot be set in painter.
Margin.Bottom	An integer indicating the width of the bottom margin on the printed page in the units specified for the DataWindow. You can set Margin.Bottom when using SyntaxFromSql to generate DataWindow syntax. Painter: Bottom Margin option.
Margin.Left	An integer indicating the width of the left margin on the printed page in the units specified for the DataWindow. You can set Margin.Left when using SyntaxFromSql to generate DataWindow syntax. Painter: Left Margin option.
Margin.Right	An integer indicating the width of the right margin on the printed page in the units specified for the DataWindow. You can set Margin.Right when using SyntaxFromSql to generate DataWindow syntax. Painter: Right Margin option.
Margin.Top	An integer indicating the width of the top margin on the printed page in the units specified for the DataWindow. You can set Margin.Top when using SyntaxFromSql to generate DataWindow syntax. Painter: Top Margin option.
Orientation	An integer indicating the print orientation. This property has no effect if the computer has no default printer. Values are: 0 – The default orientation for your printer 1 – Landscape 2 – Portrait Painter: Paper Orientation option.
OverridePrintJob	Whether you want to override the print job print settings defined in the PrintOpen method with the print specifications of the DataWindow. Values are: Yes – Override the print job print settings. No – (Default) Do not override the print job print settings. Painter: Override Print Job option.
Page.Range	A string containing the numbers of the pages you want to print, separated by commas. You can also specify a range with a dash. For example, to print pages 1, 2, and 5 through 10, enter: "1,2, 5-10". The empty string means print all. The user can specify the value in the system’s Print dialog box if the printer driver supports it.
Page.RangeInclude	An integer indicating what pages to print within the desired range. Values are: 0 – Print all. 1 – Print all even pages. 2 – Print all odd pages. The user can specify the value in the system’s Print dialog box if the printer driver supports it.
Paper.Size	An integer indicating the size of the paper used for the output: 0 – Default paper size for the printer 1 – Letter 8 1/2 x 11 in 2 – LetterSmall 8 1/2 x 11 in 3 – Tabloid 17 x 11 in 4 – Ledger 17 x 11 in 5 – Legal 8 1/2 x 14 in 6 – Statement 5 1/2 x 8 1/2 in 7 – Executive 7 1/4 x 10 1/2 in 8 – A3 297 x 420 mm 9 – A4 210 x 297 mm 10 – A4 Small 210 x 297 mm 11 – A5 148 x 210 mm 12 – B4 250 x 354 mm 13 – B5 182 x 257 mm 14 – Folio 8 1/2 x 13 in 15 – Quarto 215 x 275 mm 16 – 10x14 in 17 – 11x17 in 18 – Note 8 1/2 x 11 in 19 – Envelope #9 3 7/8 x 8 7/8 20 – Envelope #10 4 1/8 x 9 1/2 21 – Envelope #11 4 1/2 x 10 3/8 22 – Envelope #12 4 x 11 1/276 23 – Envelope #14 5 x 11 1/2 24 – C size sheet 25 – D size sheet 26 – E size sheet 27 – Envelope DL 110 x 220 mm 28 – Envelope C5 162 x 229 mm 29 – Envelope C3 324 x 458 mm 30 – Envelope C4 229 x 324 mm 31 – Envelope C6 114 x 162 mm 32 – Envelope C65 114 x 229 mm 33 – Envelope B4 250 x 353 mm 34 – Envelope B5 176 x 250 mm 35 – Envelope B6 176 x 125 mm 36 – Envelope 110 x 230 mm 37 – Envelope Monarch 3.875 x 7.5 in 38 – 6 3/4 Envelope 3 5/8 x 6 1/2 in 39 – US Std Fanfold 14 7/8 x 11 in 40 – German Std Fanfold 8 1/2 x 12 in 41 – German Legal Fanfold 8 1/2 x 13 in 255, 256 – User-defined paper size (see "Usage" below) Painter: Paper Size option.
Paper.Source	An integer indicating the bin that will be used as the paper source. The integer you use depends on the tray number used by the printer. (To determine the actual bin setting, you can query the printer with a utility that makes API calls to the printer driver.) Typical values are: 0 – Default 1 – Upper 2 – Lower 3 – Middle 4 – Manual 5 – Envelope 6 – Envelope manual 7 – Auto 8 – Tractor 9 – Smallfmt 10 – Largefmt 11 – Large capacity 14 – Cassette Painter: Paper Source option.
Preview	Whether the DataWindow object is displayed in preview mode. Values are: Yes – Display in preview mode. No – (Default) Do not display in preview mode.
Preview.Background	Whether the background settings of the DataWindow and controls display in the print preview. Values are: Yes – Display in preview mode. No – (Default) Do not display in preview mode. Painter: Preview Shows Background option.
PrinterName	A string containing the name of the printer you want to use to print the DataWindow report. If the printer name is not specified or if the named printer cannot be found at runtime, print output can be directed to the default printer for the user’s machine by setting the CanUseDefaultPrinter property. Otherwise, an error is returned. Painter: Printer Name option.
Prompt	Whether a Printer Setup dialog displays before a job prints so the user can change the paper or other settings for the current printer. Values are: Yes – (Default) Display a Printer Setup dialog. No – Do not display a Printer Setup dialog. Choosing Cancel in the Printer Setup dialog dismisses the Setup dialog; it does not cancel printing. To allow the user to cancel printing, see the Print method. For DataStores, this property is ignored; a dialog is never displayed. Painter: Prompt Before Printing check box.
Quality	An integer indicating the quality of the output. Values are: 0 – Default 1 – High 2 – Medium 3 – Low 4 – Draft The user can specify the value in the system’s Print dialog box if the printer driver supports it.
Scale	An integer specifying the scale of the printed output as a percent. The scaling percentage is passed to the print driver. If you have problems with scaling, you might be using a driver that does not support scaling. The user can specify the value in the system’s Print dialog box if the printer driver supports it. For more information, see your print driver documentation.

Usage

In the painter

Select the DataWindow by deselecting all controls; then set values in the Properties view, Print Specifications tab.

To specify a user-defined paper size, set the Paper.Size property to 255 or 256, then set the Print.CustomPage.Length and Print.Custom.Page.Width properties to the desired size. With Paper.Size set to 255, Length and Width are in the units specified for the report on the General page in the Properties view. For example:

// DataWindow Units set to 1/1000 inch
dw1.Modify("DataWindow.Print.Paper.Size=255")
//9.875 inches long
dw1.Modify("DataWindow.Print.CustomPage.Length=9875")
//7.375 inches wide
dw1.Modify("DataWindow.Print.CustomPage.Width=7375")

With Paper.Size set to 256, Length and Width are in millimeters:

dw1.Modify("DataWindow.Print.Paper.Size=256")
//25.4 centimeters long
dw1.Modify("DataWindow.Print.CustomPage.Length=254")
//19.5 centimeters wide
dw1.Modify("DataWindow.Print.CustomPage.Width=195")

Examples

Example 1

strData = dw1.Describe("DataWindow.Print.Scale")

Example 2

dw1.Modify("DataWindow.Print.Paper.Size = 3")

Example 3

dw1.Modify("DataWindow.Print.Margin.Top=500")

Example 4

setting = dw1.Describe("DataWindow.Print.Buttons")

Example 5

dw1.Modify("DataWindow.Print.Buttons = 'Yes'")