Bandname.property

Description

Settings for the color, size, and pointer of a band in the DataWindow object.

Applies to

DataWindows

Syntax

Describe and Modify argument:

"DataWindow.bandname{.#}.property { = value }"

Parameter

Description

bandname

The identifier of a band in the DataWindow object. Values are:

  • Detail

  • Footer

  • Summary

  • Header

  • Trailer

  • Tree.Level

#

The number of the group or TreeView level you want when bandname is Header, Trailer, or Tree.Level. The group must exist.

property

A property that applies to the band, as listed in the table below.

value

Values for the properties are shown in the following table.

Property for Bandname

Value

Color

(exp) A long specifying the color (the red, green, and blue values) to be used as the band’s background color. Value can be a quoted DataWindow expression.

Painter: General tab.

Height

An integer specifying the height of the detail area in the unit of measure specified for the DataWindow.

Painter: General tab.

For another way of setting the height of the detail band, see the SetDetailHeight method.

Height.AutoSize

Allows the band to grow to display a row, picture, or nested report without cutting off any of its content. In the detail band, selecting this property sets the minimum height for all rows to the size specified by the Height property for the band. Values are:

  • No – Fixes the band height to the size set for the Height property of the band.

  • Yes – Adjusts the band height to accomodate the full content of a row or the controls in the band. However, the band height cannot be reduced below the value set for the Height property of the band.

This property can be especially useful to set on the detail band when it contains rows with a text column that you want to display without cutting off any of the text. The height of the detail band must not grow larger than a page, except when it contains nested DataWindows with the Report.Height.AutoSize property set to Yes.

You can set this property on individual columns and controls as well as on the band itself. For more information, see the Height.AutoSize property for DataWindow objects.

There are some limitations on the use of this property:

  • The Height.Autosize property is not supported on DataWindows with Graph or Label presentation styles.

  • Nested report overflow to the next page is supported in detail bands only.

  • Bands cannot be autosized if autosizing would preclude the display of at least one detail band row per page.

Painter: General tab when the band is selected.

Pointer

(exp) A string specifying a value of the Pointer enumerated datatype or the name of a cursor file (.CUR) to be used for the pointer. See the SetPointer method for a list of Pointer values. Pointername can be a quoted DataWindow expression. This property is not supported in Web DataWindows.

Painter: Pointer tab.

Suppress

A boolean that lets you suppress group headers after page breaks. You can set this property on group header bands only. When a group listing straddles a page break, all group headers for which you set this property will be suppressed. The suppressed headers do not display at the top of the page. However, if the page break coincides with the start of a new group, only headers above the current group header can be suppressed. Values are:

  • No – Does not suppress group headers.

  • Yes – Suppresses group headers.

Painter: General tab when a group header band is selected.

Usage


In the painter

Select the band by clicking the gray divider for the band. Set the value in the Properties view.

Examples

Example 1

[Visual Basic]
Dim PropVal As String
PropVal = DW1.GetProperty("DataWindow.Detail.Height")
dw1.SetProperty("DataWindow.Detail.Pointer", "hand.cur")

PropVal = DW1.Describe("DataWindow.Detail.Height")
PropVal = dw1.Describe("DataWindow.Detail.Height.AutoSize")
dw1.Modify("DataWindow.Detail.Pointer='hand.cur'")

dw1.Modify("DataWindow.Detail.Pointer=' ~"Cross!~" ~t if(emp_status=~"a~", ~"HourGlass!~", ~"Cross!~")'")

dw1.Modify("DataWindow.Footer.Height=250")
ColorVal = RGB(200, 200, 500)
dw1.Modify("DataWindow.Trailer.2.Height=500")
dw1.Modify("DataWindow.Summary.Pointer='total.cur'")

[C#]
string PropVal;
PropVal = DW1.GetProperty("DataWindow.Detail.Height");
DW1.SetProperty("DataWindow.Detail.Pointer", "hand.cur");

PropVal = DW1.Describe("DataWindow.Detail.Height");
PropVal = DW1.Describe("DataWindow.Detail.Height.AutoSize");
DW1.Modify("DataWindow.Detail.Pointer='hand.cur'");

DW1.Modify("DataWindow.Detail.Pointer=' ~"Cross!~" ~t if(emp_status=~"a~", ~"HourGlass!~", ~"Cross!~")'")

DW1.Modify("DataWindow.Footer.Height=250");
ColorVal = RGB(200, 200, 500);
DW1.Modify("DataWindow.Trailer.2.Height=500");
DW1.Modify("DataWindow.Summary.Pointer='total.cur'");