Settings for a DataWindow object whose presentation style is Crosstab.
DataWindows
Describe and Modify argument:
"DataWindow.Crosstab.property { = value }"
Parameter |
Description |
|---|---|
property |
A property for a Crosstab DataWindow. Properties and their settings are listed in the table below. |
value |
A string expression listing the items to be assigned to the property. For Crosstab properties, value is always quoted and can be a DataWindow expression. |
Property for Crosstab |
Value |
|---|---|
Columns |
(exp) A string containing a comma- or tab-separated list of the names of columns that make up the columns of the crosstab. These are the columns that display across the top of the crosstab. |
Rows |
(exp) A string containing a comma- or tab-separated list of the names of columns that make up the rows of the crosstab. |
SourceNames |
(exp) A string containing a comma-separated list of column names to be displayed in the Crosstab Definition dialog box. The default names are the column names from the database. |
StaticMode |
A string indicating whether a dynamic crosstab should be put into a static mode. The dynamic crosstab remains in static mode until you set StaticMode to No. While the dynamic crosstab is in static mode, you can manipulate the properties of individual columns. Values are:
|
Values |
(exp) A string containing a comma- or tab-separated list of expressions that will be used to calculate the values of the crosstab. |
For DataWindow objects with the Crosstab presentation style, set the values in the Crosstab Definition dialog box. To display the dialog box, right-click in the Design view to display the pop-up menu and select Crosstab.
[Visual Basic]
setting = dw1.Describe("DataWindow.Crosstab.Columns")
dw1.Modify("DataWindow.Crosstab.Columns='dept_id'")
dw1.Modify("DataWindow.Crosstab.Rows='salary'")
dw1.Modify("DataWindow.Crosstab.Values='empname'")
dw1.Modify("DataWindow.Crosstab.StaticMode='yes'")
CrosstabDialog function
