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 native PDF format using PDFlib.

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.XHTML.TemplateCount

 

 

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

Obsolete property

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

Export.XHTML.Template[ ].Name

 

 

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

Obsolete property

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

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.

Obsolete property

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

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.

PushCutControlToNextPage

x

 

Whether to move and display the control (text in a column) on the next page when there are page breaks in the column.

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.