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'")

See also