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.)
You can change the following properties without forcing the DataWindow control to rebuild the crosstab:
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 |
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.
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.
