Print.property

Description

Properties that control the printing of a DataWindow.

Applies to

DataWindows

Syntax

DataWindow .NET dot notation:

dw_control.PrintProperties.property

Describe and Modify argument:

"DataWindow.Print.property { = value }"

DataWindowSyntaxFromSql:

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
Buttons	Whether buttons display on the printed output. Values are: Yes – Buttons are displayed. No – Buttons are not displayed.
CanUseDefault Printer	Whether a report can be printed on the default system printer if the printer specified by the PrinterName property is not valid.
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.
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.
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.
Columns.Width	An integer specifying the width of the newspaper-style columns in the units specified for the DataWindow.
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.
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 DataWindowSyntaxFromSql to generate DataWindow syntax.
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 DataWindowSyntaxFromSql to generate DataWindow syntax.
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 DataWindowSyntaxFromSql to generate DataWindow syntax.
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 DataWindowSyntaxFromSql to generate DataWindow syntax.
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
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.
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)
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
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.
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.
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.
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 window, Print Specifications category.

In DataWindow .NET, you can use the PrintProperties class to set print properties using dot notation. Note that the names of some properties of the PrintProperties class differ from the names of the DataWindow object property, and some take a different value. For example, the Color DataWindow object property takes an integer value, and the equivalent ColorOutput PrintProperties property takes a boolean value.

See the description of the PrintProperties class in the online Help in Visual Studio .NET for a complete list of properties.

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 DataWindow 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

[Visual Basic]
dw1.PrintProperties.PaperSize = 3

Example 2

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

Example 3

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

Example 4

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

Example 5

dw1.PrintProperties.ShowButtons = 'Yes'

Example 6

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

Example 7

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