Controls in a DataWindow and their properties

The tables in this section list the properties that apply to DataWindow objects and SyntaxFromSql (Group, Style, and Title) keywords.


Properties for the DataWindow object

An x in the M (Modify) column means you can change the property. An x in the S column means you can use the property with the SyntaxFromSql method. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Obsolete feature

An obsolete feature means a feature that is available, but is no longer eligible for technical support and will no longer be enhanced.

Property for the DataWindow

M

S

Description

Attributes

 

 

All general properties.

Bands

 

 

List of bands.

Bandname.property

x

 

Color, height, and so on for a band, where bandname is Detail, Footer, Header, Summary, Trailer, or TreeView.Level.

Bandname.Text

x

 

Rich text content where bandname is Detail, Footer, or Header.

Brushmode

x

 

Setting used for background or primary gradient.

Color

x

x

Background color.

Column.Count

 

 

Number of columns.

Crosstab.property

x

 

Settings for a crosstab DataWindow.

CSSGen.property

x

 

Settings that specify the physical path to which a generated CSS style sheet is published and the URL where the style sheet is located.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Data

 

 

Description of data.

Data.HTML

 

 

Description of the data and format of the DataWindow in HTML format.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Data.HTMLTable

 

 

Description of the data in the DataWindow in HTML table format.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Data.XHTML

 

 

A string containing the row data content of the DataWindow object in XHTML format.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Data.XML

 

 

A string containing the row data content of the DataWindow object in XML format.

Data.XMLDTD

 

 

A string containing the full document type definition (DTD) of the XML output for a DataWindow object.

Data.XMLSchema

 

 

A string containing the full schema of the XML output of a DataWindow object.

Data.XMLWeb

 

 

A string containing browser-specific JavaScript that performs the XSLT transformation on the browser after the XML Web DataWindow generator generates all necessary components.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Data.XSLFO

 

 

A string containing XSL Formatting Objects (XSL-FO) that represents the data and presentation of the DataWindow object.

Detail.property

x

 

Color, height, and so on for the detail band.

EditMask.property

x

 

Settings for EditMask edit style.

Export.PDF.Distill.CustomPostScript

x

 

Setting that enables you to specify the PostScript printer driver settings used when data is exported to PDF using the Distill! method.

Export.PDF.Method

x

 

Setting that determines whether data is exported to PDF from a DataWindow object by printing to a PostScript file and distilling to PDF, or by saving in XSL Formatting Objects (XSL-FO) format and processing to PDF.

Export.PDF.NativePDF.Author

x

 

Setting that enables you to specify the author for the PDF file when using the PDFlib method to print data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.CustomOrientation

x

 

Setting that enables you to specify the page orientation when using the PDFlib method to print data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.CustomSize

x

 

Setting that enables you to specify the paper size when using the PDFlib method to print data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.ImageFormat

x

 

Setting that enables you to select a format for images in the PDF file when you use the PDFlib method to save data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.Keywords

x

 

Setting that enables you to specify the keywords for the PDF file when using the PDFlib method to print data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.MasterPassword

x

 

Setting that enables you to set a password for the administration permissions -- print, copy, edit, etc. -- to the generated PDF file, when you use the PDFlib method to save data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.PDFStandard

x

 

Setting that enables you to select a PDF conformance level when you use the PDFlib method to save data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.Restrictions

x

 

Setting that enables you to set the permissions (including copying/printing/editing) of the generated PDF file, when you use the PDFlib method to save data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.Subject

x

 

Setting that enables you to specify the subject for the PDF file when using the PDFlib method to print data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.UserPassword

x

 

Setting that enables you to set a password for opening the generated PDF file, when you use the PDFlib method to save data from a DataWindow object to a PDF file.

Export.PDF.NativePDF.UsePrintSpec

x

 

Setting that enables you to use the page orientation and paper size settings in the Print Specifications tab or in the Print.Orientation and Print.Paper.Size properties, when you use the PDFlib method to save data from a DataWindow object to a PDF file.

Export.PDF.XSLFOP.Print

x

 

Setting that enables you to send a DataWindow object directly to a printer using platform-independent Java printing when using the XSL-FO method to export to PDF. This is an option of the Apache FOP processor.

Export.XHTML.TemplateCount

 

 

The number of XHTML export templates associated with a DataWindow object.

Export.XHTML.Template[ ].Name

 

 

The name of an XHTML export template associated with a DataWindow object.

Export.XHTML.UseTemplate

x

 

Setting that optionally controls the logical structure of the XHTML generated by a DataWindow object from a DataWindow data expression using dot notation.

Export.XML.HeadGroups

x

 

Setting that causes elements, attributes, and all other items above the Detail Start element in an XML export template for a group DataWindow to be iterated for each group in the exported XML.

Export.XML.IncludeWhitespace

x

 

Setting that determines whether the XML document is formatted by inserting whitespace characters (carriage returns, linefeeds, tabs, and spacebar spaces).

Export.XML.MetaDataType

x

 

Setting that controls the type of metadata generated with the XML exported from a DataWindow object using the SaveAs method or a .Data.XML expression.

Export.XML.SaveMetaData

x

 

Setting that controls the storage format for the metadata generated with the XML exported from a DataWindow object using the SaveAs method or a .Data.XML expression.

Export.XML.TemplateCount

 

 

The number of XML export templates associated with a DataWindow object.

Export.XML.Template[ ].Name

 

 

The name of an XML export template associated with a DataWindow object.

Export.XML.UseTemplate

x

 

Setting that optionally controls the logical structure of the XML exported from a DataWindow object using the SaveAs method or the .Data.XML property.

FirstRowOnPage

 

 

The row number of the first displayed row.

Font.Bias

x

 

Treat fonts as display or printer.

Footer.property

x

 

Color, height, and so on for the footer band (see Bandname.property in this table).

Gradient.property

x

 

Settings that control the gradient display in a DataWindow object.

Grid.ColumnMove

x

 

Whether the user can drag to reposition columns.

Grid.Lines

x

 

Options for lines in grid DataWindow and crosstab.

Header.#.property

x

 

Color, height, and so on for a group's header band.

Header.property

x

 

Color, height, and so on for the header band.

Help.property

x

 

Help settings for DataWindow actions.

HideGrayLine

x

 

Whether a gray line displays at page boundaries.

HorizontalScrollMaximum

 

 

Width of scroll box in the horizontal scroll bar.

HorizontalScrollMaximum2

 

 

Width of second scroll box when scroll bar is split.

HorizontalScrollPosition

x

 

Position of the scroll box in the scroll bar.

HorizontalScrollPosition2

x

 

Position of scroll box in second split scroll bar.

HorizontalScrollSplit

x

 

The position of the split in the scroll bar.

HTMLDW

x

 

(exp) Whether HTML for the DataWindow is interactive and coordinated with a server component for retrievals and updates.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

HTMLGen.property

x

 

(exp) Settings for HTML generation.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

HTMLTable.property

x

 

Settings for the display of DataWindow data when displayed in HTML table format.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Import.XML.Trace

x

 

Setting that determines whether import trace information is written to a log file.

Import.XML.TraceFile

x

 

Specifies the name and location of an import trace file.

Import.XML.UseTemplate

x

 

Setting that optionally controls the logical structure of the XML imported from an XML file to a DataWindow object using the ImportFile method.

JSGen.property

x

 

Settings that specify the physical path to which generated JavaScript is published and the URL indicating the location of the generated JavaScript.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Label.property

x

x

Settings for the Label presentation style.

LastRowOnPage

 

 

The last visible row on the page.

Message.Title

x

x

The title of the dialog box that displays errors.

Nested

 

 

Whether the DataWindow has nested reports.

NoUserPrompt

x

 

Determines whether an error message is displayed to the user.

Objects

 

 

The controls in the DataWindow.

OLE.Client.property

x

 

Settings for the DataWindow as OLE client.

Picture.property

x

 

Settings that control the background picture display in a DataWindow object.

Pointer

x

 

(exp) The pointer when over the DataWindow.

Print.Preview.property

x

 

Various settings for print preview.

Print.property

x

x

Various settings for printing.

Printer

x

 

The currently selected printer.

Processing

 

 

Processing required by the presentation style.

QueryMode

x

 

Whether the DataWindow is in query mode.

QuerySort

x

 

Whether to sort the result set from the query.

ReadOnly

x

 

Whether the DataWindow is read-only.

Retrieve.AsNeeded

x

 

Whether to retrieve data only as needed.

RichText.property

x

 

Settings for a RichText DataWindow.

Row.Resize

x

 

Whether user can change the height of rows.

Rows_Per_Detail

 

x

Number of rows in each column of N-Up style.

Selected

x

 

List of selected controls.

Selected.Data

 

 

List of selected data.

Selected.Mouse

x

 

Whether user can use the mouse to select.

ShowBackColorOnXP

x

 

Whether the background color that you select for a button displays on Windows XP.

ShowDefinition

x

 

(exp) Display column names instead of data.

Sparse

x

 

(exp) The repeating columns to be suppressed.

Storage

 

 

The amount of storage used by DataWindow.

StoragePageSize

 

 

The default page size for DataWindow storage.

Summary.property

x

 

Color, height, and so on for the summary band.

Syntax

 

 

The syntax of the DataWindow.

Syntax.Data

 

 

The data of the DataWindow in parse format.

Syntax.Modified

x

 

Whether the syntax has been modified.

Table.property

x

 

Various settings for the database.

Table.sqlaction.property

x

 

Stored procedures for update activity.

Timer_Interval

x

x

The milliseconds between timer events.

Transparency (DataWindow objects)

x

 

Setting that controls the transparency of the background/primary gradient color.

Trailer.#.property

x

 

Color, height, and so on for a group's trailer band.

Tree.property

x

 

Settings for a TreeView DataWindow.

Tree.Leaf.TreeNodeIconName

x

 

The file name of the tree node icon in the detail band of a TreeView DataWindow.

Tree.Level.#.property

x

 

The file name of the icon for a TreeView node in a TreeView level band when the icon is in either the expanded or collapsed state.

Units

 

x

The unit of measure for the DataWindow.

VerticalScrollMaximum

 

 

The height of the scroll box in the scroll bar.

VerticalScrollPosition

x

 

The position of the scroll box in the scroll bar.

XHTMLGen.Browser

x

 

A string that identifies the browser in which XHTML generated within an XSLT style sheet is displayed.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

XMLGen.property

x

 

Settings that specify the physical path to which XML is published and the URL referenced by the JavaScript that transforms the XML to XHTML.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

XSLTGen.property

x

 

Settings that specify the physical path to which the generated XSLT style sheet is published and the URL referenced by the JavaScript that transforms the XML to XHTML.

Obsolete property

This property is obsolete because the Web DataWindow technology is obsolete.

Zoom

x

 

The scaling percentage of the DataWindow.


Properties for Button controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a Button

M

Description

AccessibleDescription

x

A description of the control for use by assistive technology tools.

AccessibleName

x

A descriptive label for the control.

AccessibleRole

 

A description of the kind of user-interface element that the control is.

Background.property

x

Background settings for the button.

Color

x

(exp) The text color.

DefaultPicture

x

Whether or not the action's default picture is to be used on the button (user-defined action has no default picture).

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

Filename

x

(exp) Name of the file containing the picture to be used on the button (if not specified, just the text is used).

Font.property

x

(exp) Font settings for the text.

HTextAlign

x

(exp) How the text in the button is horizontally aligned. Values are: 0 (center), 1 (left), 2 (right).

Height

x

(exp) The height of the button control.

HideSnaked

x

Whether the button control appears once per page when printing newspaper columns.

Moveable

x

Whether the user can move the button control.

Name

 

The name of the button control.

OriginalSize

x

Whether the button image is shown in its original size.

Pointer

x

(exp) The pointer image when it is over the button control.

Resizeable

x

Whether the user can resize the button control.

SlideLeft

x

(exp) Whether the button control moves left to fill in empty space.

SlideUp

x

(exp) How the button control moves up to fill in empty space.

SuppressEventProcessing

x

Whether or not ButtonClicked and ButtonClicking events are fired for this particular button.

TabSequence

x

The position of the button in the tab order.

Tag

x

(exp) The tag text for the button control.

Text

x

(exp) The displayed text.

Type

 

The control's type, which is button.

VTextAlign

x

(exp) How the text in the button is vertically aligned. Values are: 0 (center), 1 (top), 2 (bottom), 3 (multiline).

Visible

x

(exp) Whether the button control is visible.

Width

x

(exp) The width of the button control.

X

x

(exp) The x coordinate of the button control.

Y

x

(exp) The y coordinate of the button control.


Properties for Column controls in DataWindow objects

An x in the M (Modify) column means you can change the property. An x in the S column means you can use the property with the SyntaxFromSQL method. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a Column

M

S

Description

AccessibleDescription

x

 

A description of the control for use by assistive technology tools.

AccessibleName

x

 

A descriptive label for the control.

AccessibleRole

 

 

A description of the kind of user-interface element that the control is.

Accelerator

x

 

(exp) The accelerator key for the column.

Alignment

x

 

(exp) The alignment of the column's text.

Attributes

 

 

A list of the properties of the column.

Background.property

x

x

(exp) Background settings for the column.

Band

 

 

The band containing the column.

BitmapName

 

 

Whether the column's content names a picture that will be displayed instead of the text.

Border

x

x

(exp) The type of border around the column.

CheckBox.property

x

 

Settings for CheckBox edit style.

Color

x

x

(exp) The text color.

ColType

 

 

The column's datatype.

Criteria.property

x

 

Settings for column in Prompt for Criteria dialog box.

dbAlias

x

 

An alias for the name of the database column.

dbName

x

 

The name of the database column.

dddw.property

x

 

Settings for DropDownDataWindow edit style.

ddlb.property

x

 

Settings for DropDownListBox edit style.

Edit.property

x

x

Settings for Edit edit style.

EditMask.property

x

 

Settings for EditMask edit style.

Font.property

x

x

(exp) Font settings for the column text.

Format

x

 

(exp) The column's display format.

Height

x

 

(exp) The height of the column.

Height.AutoSize

x

 

Whether column height is adjusted to fit the data.

Height.HasMinHeight

x

 

Whether the column should maintain its minimum height.

HideSnaked

x

 

Whether the control appears once per page when printing newspaper columns.

HTML.property

x

 

(exp) Settings for creating hyperlinks for column data.

Identity

x

 

Whether the DBMS sets the column's value.

ID

 

 

The number of the column.

Ink.property

x

 

Settings for Ink attributes of the InkEdit edit style.

InkEdit.property

x

 

Settings for InkEdit edit style.

Initial

x

 

The initial value in the column for a new row.

Key

x

 

Whether column is part of the table's primary key.

Moveable

x

 

Whether the user can move the column.

Name

 

 

The name of the column.

Pointer

x

 

(exp) The pointer's image when it is over the column.

Protect

x

 

(exp) Whether the column is protected from changes.

RadioButtons.property

x

 

Settings for RadioButton edit style.

Resizeable

x

 

Whether the user can resize the column.

RichEdit.property

x

 

Settings for RichText edit style.

RightToLeft

x

 

Whether the column is set for right-to-left reading.

SlideLeft

x

 

(exp) Whether the column moves left to fill in space.

SlideUp

x

 

(exp) How the column moves up to fill in space.

TabSequence

x

 

The position of the column in the tab order.

Tag

x

 

(exp) The tag text for the column.

Type

 

 

The control's type, which is Column.

Update

x

 

Whether the column is updatable.

Validation

x

 

(exp) The validation expression for the column.

ValidationMsg

x

 

(exp) The message displayed when validation fails.

Values (for columns)

x

 

The values in the column's code table.

Visible

x

 

(exp) Whether the column control is visible.

Width

x

 

(exp) The width of the column.

Width.Autosize

x

 

In Grid style DataWindows, determines whether the column's width adjusts according to the data it contains.

X

x

 

(exp) The x coordinate of the column.

Y

x

 

(exp) The y coordinate of the column.


Properties for Computed Field controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a computed field

M

Description

AccessibleDescription

x

A description of the control for use by assistive technology tools.

AccessibleName

x

A descriptive label for the control.

AccessibleRole

 

A description of the kind of user-interface element that the control is.

Alignment

x

(exp) The alignment of the computed field's text.

Attributes

 

A list of the properties of the computed field.

Background.property

x

(exp) Background settings for the computed field.

Band

 

The band containing the computed field.

Border

x

(exp) The type of border around the computed field.

Color

x

(exp) The text color.

ColType

 

The column's datatype.

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

Expression

x

The expression for the computed field.

FocusRectangle

x

Determines whether a rectangle displays around the selected control.

Font.property

x

(exp) Font settings for the computed field.

Format

x

(exp) The computed field's display format.

Height

x

(exp) The height of the computed field.

Height.AutoSize

x

Whether the computed field's height is adjusted to fit the data.

Height.HasMinHeight

x

Whether the computed field should maintain its minimum height.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

HTML.property

x

(exp) Settings for creating hyperlinks for the computed field.

Moveable

x

Whether the user can move the computed field.

Name

 

The name of the computed field.

Pointer

x

(exp) The pointer image when it is over the computed field.

Resizeable

x

Whether the user can resize the computed field.

SlideLeft

x

(exp) Whether the computed field moves left to fill in space.

SlideUp

x

(exp) How the computed field moves up to fill in empty space.

TabSequence

x

The position of the computed field in the tab order.

Tag

x

(exp) The tag text for the computed field.

Type

 

The control's type, which is Compute.

Visible

x

(exp) Whether the computed field control is visible.

Width

x

(exp) The width of the computed field.

X

x

(exp) The x coordinate of the computed field.

Y

x

(exp) The y coordinate of the computed field.


Properties for Graph controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a Graph

M

Description

AccessibleDescription

x

A description of the control for use by assistive technology tools.

AccessibleName

x

A descriptive label for the control.

AccessibleRole

 

A description of the kind of user-interface element that the control is.

Attributes

 

A list of the properties of the graph.

Axis

x

(exp) List of items (categories, series, or values) for the axis.

Axis.property

x

(exp) Properties for a graph axis.

Axis.DispAttr

x

(exp) Display properties for an axis (see DispAttr.fontproperty in this table).

BackColor

x

(exp) The background color of the graph.

Band

 

The band containing the graph.

Border

x

(exp) The type of border around the graph.

Category

x

(exp) List of categories for the axis (see Axis in this table).

Category.property

x

(exp) Properties for the Category axis (see Axis.property in this table).

Category.DispAttr

x

(exp) Display properties for the Category axis (see DispAttr.fontproperty in this table).

Color

x

(exp) The text color.

Depth

x

(exp) The depth of a 3D graph.

DispAttr.fontproperty

x

Font settings for various components of the graph.

Elevation

x

(exp) The elevation of a 3D graph.

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

FocusRectangle

x

Determines whether a rectangle displays around the selected control.

GraphType

x

(exp) The type of graph (pie, bar, and so on).

Height

x

(exp) The height of the graph.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

Legend

x

(exp) The location of the legend.

Legend.DispAttr.fontproperty

x

(exp) Display properties for the legend.

Moveable

x

Whether the user can move the graph.

Name

 

The name of the graph control.

OverlapPercent

x

(exp) The overlap between data markers in different series.

Perspective

x

(exp) The distance of the graph from the front of the window.

Pie.DispAttr.fontproperty

x

(exp) Display properties for the pie slice labels.

PlotNullData

x

Whether a continuous line is drawn in a line graph when there is no data.

Pointer

x

(exp) The pointer image when it is over the graph.

Range

 

The rows in the DataWindow that are included in the graph.

Render3D

x

Whether the graph is rendered in the DirectX 3D style.

Resizeable

x

Whether the user can resize the graph.

Rotation

x

(exp) The left-to-right rotation of a 3D graph.

Series

x

(exp) List of series for the axis (see Axis in the table).

Series.property

x

(exp) Properties for the Series axis (see Axis.property in this table).

Series.DispAttr

x

(exp) Display properties for the Series axis (see DispAttr.fontproperty in this table).

ShadeColor

x

(exp) The color of the back edge for 3D data markers.

SizeToDisplay

x

(exp) Whether to size the graph to the display area.

SlideLeft

x

(exp) Whether the graph moves left to fill in empty space.

SlideUp

x

(exp) How the graph moves up to fill in empty space.

Spacing

x

(exp) The gap between categories.

TabSequence

x

The position of the graph in the tab order.

Tag

x

(exp) The tag text for the graph.

Title

x

(exp) The graph's title.

Title.DispAttr.fontproperty

x

(exp) Display properties for the title.

Type

 

The control's type, which is graph.

Values

x

(exp) List of values for the axis (see Axis in the table).

Values.property

x

(exp) Properties for the Values axis (see Axis.property in the table).

Values.DispAttr

x

(exp) Display properties for the Values axis (see DispAttr.fontproperty in the table).

Visible

x

(exp) Whether the graph control is visible.

Width

x

(exp) The width of the graph.

X

x

(exp) The x coordinate of the graph.

Y

x

(exp) The y coordinate of the graph.


Properties for GroupBox controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a GroupBox

M

Description

AccessibleDescription

x

A description of the control for use by assistive technology tools.

AccessibleName

x

A descriptive label for the control.

AccessibleRole

 

A description of the kind of user-interface element that the control is.

Attributes

 

A list of the properties of the GroupBox control.

Background.property

x

(exp) Background settings for the GroupBox control.

Band

 

The band containing the GroupBox control.

Border

x

(exp) Border style: 2 (box), 5 (3D lowered), 6 (3D raised).

Color

x

(exp) The text color.

Font.property

x

(exp) Font settings for the text.

Height

x

(exp) The height of the GroupBox control.

HideSnaked

x

Whether the GroupBox control appears once per page when printing newspaper columns.

Moveable

x

Whether the user can move the GroupBox control.

Name

 

The name of the GroupBox control.

Pointer

x

(exp) The pointer image when it is over the GroupBox control.

Resizeable

x

Whether the user can resize the GroupBox control.

SlideLeft

x

(exp) Whether the GroupBox control moves left to fill in empty space.

SlideUp

x

(exp) How the GroupBox control moves up to fill in empty space.

Tag

x

(exp) The tag text for the GroupBox control.

Text

x

(exp) The displayed text.

Type

 

The control's type, which is GroupBox.

Visible

x

(exp) Whether the GroupBox control is visible.

Width

x

(exp) The width of the GroupBox control.

X

x

(exp) The x coordinate of the GroupBox control.

Y

x

(exp) The y coordinate of the GroupBox control.


Properties for the Group keyword

You use these properties when generating DataWindow source code with the SyntaxFromSql method.

Property

Description

NewPage (Group keywords)

Whether a change in a group column's value causes a page break.

ResetPageCount

Whether a new value in a group column restarts page numbering.


Properties for InkPicture controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for an InkPicture

M

Description

BackImage

 

The column containing the background image for the InkPicture.

Band

 

The band containing the InkPicture.

Border

x

(exp) The type of border around the InkPicture.

Enabled

x

(exp) Whether the control is enabled.

Height

x

(exp) The height of the InkPicture.

Ink.property

x

(exp) Attributes of the ink in the InkPicture.

InkPic.property

x

(exp) Properties that specify the behavior of the InkPicture.

KeyClause

x

(exp) The key clause used when retrieving the blob.

Moveable

x

Whether the user can move the InkPicture.

Name

 

The name of the InkPicture control.

Pointer

x

(exp) The pointer image when it is over the InkPicture.

Resizeable

x

Whether the user can resize the InkPicture.

SlideLeft

x

(exp) Whether the InkPicture moves left to fill in empty space.

Table (for InkPicture and TableBlobs)

x

(exp) The table that contains large binary columns used in the control.

Tag

x

(exp) The tag text for the InkPicture.

Visible

x

(exp) Whether the InkPicture control is visible.

Width

x

(exp) The width of the InkPicture.

X

x

(exp) The x coordinate of the InkPicture.

Y

x

(exp) The y coordinate of the InkPicture.


Properties for Line controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a Line

M

Description

Attributes

 

A list of the properties of the line.

Background.property

x

(exp) Background settings for the line.

Band

 

The band containing the line.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

Moveable

x

Whether the user can move the line.

Name

 

The name of the line control.

Pen.property

x

(exp) Appearance settings of the line.

Pointer

x

(exp) The pointer image when it is over the line.

Resizeable

x

Whether the user can resize the line.

SlideLeft

x

(exp) Whether the line moves left to fill empty space.

SlideUp

x

(exp) How the line moves up to fill empty space.

Tag

x

(exp) The tag text for the line.

Type

 

The control's type, which is Line.

Visible

x

(exp) Whether the Line control is visible.

X1, X2

x

(exp) The x coordinate of each end of the line.

Y1, Y2

x

(exp) The y coordinate of each end of the line.


Properties for OLE Object controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for OLE Object control

M

Description

Activation

x

The way the OLE Object control is activated.

Attributes

 

A list of the properties of the OLE Object control.

Band

 

The band containing the OLE Object control.

BinaryIndex

 

An internal pointer.

Border

x

(exp) The type of border around the OLE Object control.

ClientName

x

The name of the OLE client in the server window.

ContentsAllowed

x

Whether the control can be embedded, linked, or both.

DisplayType

x

Whether the control displays an icon or contents.

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

FocusRectangle

x

Determines whether a rectangle displays around the selected control.

GroupBy

x

(exp) The grouping columns for the transferred data.

Height

x

(exp) The height of the OLE Object control.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

LinkUpdateOptions

x

How a linked control is updated.

Moveable

x

Whether the user can move the OLE Object control.

Name

 

The name of the OLE Object control.

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

Pointer

x

(exp) The pointer image when it is over the control.

Range

 

Method for choosing the rows transferred to the OLE control.

Resizeable

x

Whether the user can resize the OLE Object control.

SizeToDisplay

x

(exp) Whether the OLE Object control is automatically sized to the display area.

SlideLeft

x

(exp) Whether the control moves left to fill in space.

SlideUp

x

(exp) How the control moves up to fill in space.

TabSequence

x

The position of the control the tab order.

Tag

x

(exp) The tag text for the control.

Target

x

(exp) The columns or expressions whose data you want to transfer to the OLE Object control.

Type

 

The control's type, which is OLE.

Visible

x

(exp) Whether the control is visible.

Width

x

(exp) The width of the control.

X

x

(exp) The x coordinate of the control.

Y

x

(exp) The y coordinate of the control.


Properties for Oval, Rectangle, and RoundRectangle controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property

M

Description

Attributes

 

A list of the properties of the control.

Background.property

x

(exp) Background settings for the control.

Band

 

The band containing the control.

Brush.property

x

(exp) Settings for fill pattern and color.

Height

x

(exp) The height of the control.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

Moveable

x

Whether the user can move the control.

Name

 

The name of the control.

Pen.property

x

(exp) Appearance settings of the control.

Pointer

x

(exp) The pointer image when it is over the control.

Resizeable

x

Whether the user can resize the control.

SlideLeft

x

(exp) Whether the control moves left to fill empty space.

SlideUp

x

(exp) How the control moves up to fill empty space.

Tag

x

(exp) The tag text for the control.

Type

 

The control's type, which is ellipse, rectangle, or roundrectangle.

Visible

x

(exp) Whether the control is visible.

X

x

(exp) The x coordinate of the control.

Y

x

(exp) The y coordinate of the control.


Additional properties for RoundRectangle controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Properties for Oval, Rectangle, and RoundRectangle controls in DataWindow objects also apply to RoundRectangle controls.

Property

M

Description

EllipseHeight

x

(exp) The radius of the vertical part of the rounded corner.

EllipseWidth

x

(exp) The radius of the horizontal part of the rounded corner.


Properties for Picture controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a Picture

M

Description

AccessibleDescription

x

A description of the control for use by assistive technology tools.

AccessibleName

x

A descriptive label for the control.

AccessibleRole

 

A description of the kind of user-interface element that the control is.

Attributes

 

A list of the properties of the picture.

Band

 

The band containing the picture.

Border

x

(exp) The type of border around the picture.

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

Filename

x

(exp) The file containing the picture.

FocusRectangle

x

Determines whether a rectangle displays around the selected control.

Height

x

(exp) The height of the picture.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

HTML.property

x

(exp) Settings for creating a hyperlink for the picture.

Invert

x

(exp) Whether the colors are displayed inverted.

Moveable

x

Whether the user can move the picture.

Name

 

The name of the picture control.

OriginalSize

x

Whether the picture is shown in its original size.

Pointer

x

(exp) The pointer image when it is over the picture.

Resizeable

x

Whether the user can resize the picture.

SlideLeft

x

(exp) Whether the picture moves left to fill in empty space.

SlideUp

x

(exp) How the picture moves up to fill in empty space.

TabSequence

x

The position of the picture in the tab order.

Tag

x

(exp) The tag text for the picture.

Type

 

The control's type, which is picture.

Visible

x

(exp) Whether the picture control is visible.

Width

x

(exp) The width of the picture.

X

x

(exp) The x coordinate of the picture.

Y

x

(exp) The y coordinate of the picture.


Properties for Report controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a Report

M

Description

Attributes

 

A list of the properties of the report.

Band

 

The band containing the report.

Border

x

(exp) The type of border around the report.

Criteria

x

The search condition of the WHERE clause that relates the report to the main DataWindow.

DataObject

x

The name of the DataWindow that is the nested report.

Height

x

(exp) The height of the report.

Height.AutoSize

x

Whether the height of the control will be adjusted to display all the data.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

Moveable

x

Whether the user can move the report.

Name

 

The name of the Report control.

Nest_Arguments

x

Retrieval arguments for the report.

NewPage (Report controls)

x

Whether to start the report on a new page (composite only).

Pointer

x

(exp) The pointer image when it is over the report.

Resizeable

x

Whether the user can resize the report.

SlideLeft

x

(exp) Whether the report moves left to fill in empty space.

SlideUp

x

(exp) How the report moves up to fill in empty space.

ShowBackground

x

Whether the background settings of the report display.

Tag

x

(exp) The tag text for the report.

Trail_Footer

x

Where to print the footer (composite only).

Type

 

The control's type, which is report.

Visible

x

(exp) Whether the Report control is visible.

Width

x

(exp) The width of the report.

X

x

(exp) The x coordinate of the report.

Y

x

(exp) The y coordinate of the report.


Properties for the Style keyword

You use these properties when generating DataWindow source code with the SyntaxFromSql method.

Property

Description

Detail_Bottom_Margin

Bottom margin of the detail area.

Detail_Top_Margin

Top margin of the detail area.

Header_Bottom_Margin

Bottom margin of the header area.

Header_Top_Margin

Top margin of the header area.

Horizontal_Spread

Horizontal space between columns in the detail area.

Left_Margin

The left margin of the DataWindow.

Report

Whether the DataWindow is a read-only report.

Type

The presentation style.

Vertical_Size

The height of the columns in the detail area.

Vertical_Spread

The vertical space between columns in the detail area.


Properties for TableBlob controls in DataWindow objects

An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for a TableBlob

M

Description

Attributes

 

A list of the properties of the TableBlob.

Band

 

The band containing the TableBlob.

Border

x

(exp) The type of border around the TableBlob.

ClientName

x

The name of the OLE client in the server window.

Enabled

x

(exp) Determines whether the control on a DataWindow is enabled.

FocusRectangle

x

Determines whether a rectangle displays around the selected control.

Height

x

(exp) The height of the TableBlob.

HideSnaked

x

Whether the control appears once per page when printing newspaper columns.

ID

 

The number of the TableBlob.

KeyClause

x

(exp) The key clause used when retrieving the blob.

Moveable

x

Whether the user can move the TableBlob.

Name

 

The name of the TableBlob.

OLEClass

x

(exp) The name of the TableBlob's OLE column.

Pointer

x

(exp) The pointer image when it is over the TableBlob.

Resizeable

x

Whether the user can resize the TableBlob.

SlideLeft

x

(exp) Whether the TableBlob moves left to fill empty space.

SlideUp

x

(exp) How the TableBlob moves up to fill empty space.

TabSequence

x

The position of the control in the tab order.

Tag

x

(exp) The tag text for the control.

Template

x

(exp) The file used to start the OLE application.

Type

 

The control's type, which is TableBlob.

Visible

x

(exp) Whether the TableBlob is visible.

Width

x

(exp) The width of the TableBlob.

X

x

(exp) The x coordinate of the TableBlob.

Y

x

(exp) The y coordinate of the TableBlob.


Properties for Text controls in DataWindow objects

An x in the M (Modify) column means you can change the property. An x in the S column means you can use the property with the SyntaxFromSQL method. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

Property for text

M

S

Description

AccessibleDescription

x

 

A description of the control for use by assistive technology tools.

AccessibleName

x

 

A descriptive label for the control.

AccessibleRole

 

 

A description of the kind of user-interface element that the control is.

Alignment

x

x

The alignment of the text.

Attributes

 

 

A list of the properties of the text control.

Background.property

x

x

(exp) Background settings for the text control.

Band

 

 

The band containing the text control.

Border

x

x

(exp) The type of border around the text control.

Color

x

x

(exp) The text color.

Enabled

x

 

(exp) Determines whether the control on a DataWindow is enabled.

FocusRectangle

x

 

Determines whether a rectangle displays around the select control.

Font.property

x

x

(exp) Font settings for the text.

Height

x

 

(exp) The height of the text control.

Height.AutoSize

x

 

Whether the control's height is adjusted to fit the data.

Height.HasMinHeight

x

 

Whether the control should maintain its minimum height.

HideSnaked

x

 

Whether the control appears once per page when printing newspaper columns.

HTML.property

x

 

(exp) Settings for creating a hyperlink for the text.

Moveable

x

 

Whether the user can move the text control.

Name

 

 

The name of the text control.

Pointer

x

 

(exp) The pointer image when it is over the text control.

Resizeable

x

 

Whether the user can resize the text control.

SlideLeft

x

 

(exp) Whether the text control moves left to fill space.

SlideUp

x

 

(exp) How the text control moves up to fill empty space.

TabSequence

x

 

The position of the text in the tab order.

Tag

x

 

(exp) The tag text for the text control.

Text

x

 

(exp) The displayed text.

Type

 

 

The control's type, which is Text.

Visible

x

 

(exp) Whether the control is visible.

Width

x

 

(exp) The width of the text control.

X

x

 

(exp) The x coordinate of the text control.

Y

x

 

(exp) The y coordinate of the text control.


Title keyword

You use this property when generating DataWindow source code with the SyntaxFromSql method.

Property

Description

Title("string")

The title for the DataWindow.