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 DataWindowSyntaxFromSql method. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property.

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.

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.

Data

Description of data.

Data.HTML

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

Data.HTMLTable

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

Data.XHTML

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

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.

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

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.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).

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.

HTMLGen.property

x

(exp) Settings for HTML generation.

HTMLTable.property

x

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

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.

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.

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.

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.

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.

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.

Zoom

x

The scaling percentage of the DataWindow.

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, or Trailer.

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.

Data

Description of data.

Data.HTML

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

Data.HTMLTable

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

Data.XHTML

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

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.

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

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

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 white space 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).

GraphType

x

(exp) The type of graph (pie, bar, and so on) for a Graph DataWindow. For additional Graph properties, see “Properties for Graph controls in DataWindow objects”.

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.

HTMLGen.property

x

(exp) Settings for HTML generation.

HTMLTable.property

x

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

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.

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.

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.

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.

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.

Trailer.#.property

x

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

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.

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.

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.

Zoom

x

The scaling percentage of the DataWindow.