Modifying the crosstab's properties during execution

As with other DataWindow objects, you can modify the properties of a crosstab during execution using the Modify method. Some changes require the DataWindow control to dynamically rebuild the crosstab; others do not. (If the original crosstab was static, it becomes a dynamic crosstab when it is rebuilt.)

NoteAvailability You can use this technique in all DataWindow environments.

Changes that do not force a rebuild

You can change the following properties without forcing the DataWindow control to rebuild the crosstab:

Table 2-11: Properties you can change on a crosstab DataWindow without forcing a rebuild

Properties

Objects

Alignment

Column, Compute, Text

Background

Column, Compute, Line, Oval, Rectangle, RoundRectangle, Text

Border

Column, Compute, Text

Brush

Line, Oval, Rectangle, RoundRectangle

Color

Column, Compute, Text

Edit styles (dddw, ddlb, checkbox, edit, editmask, radiobutton, richtext)

Column

Font

Column, Compute, Text

Format

Column, Compute

Pen

Line, Oval, Rectangle, RoundRectangle

Pointer

Column, Compute, Line, Oval, Rectangle, RoundRectangle, Text

Changes that force a rebuild

If you change any other properties, the DataWindow control rebuilds the structure of the crosstab when Modify is called. You should combine all needed expressions into one Modify call so that the DataWindow control has to rebuild the crosstab only once.

Default values for properties

For computations derived from existing columns, the DataWindow control by default uses the properties from the existing columns. For completely new columns, properties (such as font, color, and so on) default to the first column of the preexisting crosstab. Properties for text in headers default to the properties of the first text control in the preexisting crosstab’s first header line.

For more about the Modify method, see Chapter 3, “Dynamically Changing DataWindow Objects.” For details on the DataWindow object properties, see the DataWindow Reference.