Cross Tab

See Also

Category Automation
Default Catalog Visual FoxPro Catalog\Foundation Classes\Automation
Class _xtab
Base Class Custom
Class Library _utility.vcx
Parent Class _custom
Sample ...\Samples\Vfp98\Solution\OLE\Automate.scx

Remarks

This class uses the the Cross-Tab Wizard engine to generate a cross tab report when placed on a form.

To use, drop the class on a project or form or, from the Component Gallery Item Shortcut menu, select Add to Project or Add to Form. When you add the class to a form in a data environment, Visual FoxPro opens a builder so you can specify the appropriate lDisplayNulls, lTotalRows, nTotalOption, and lBrowseAfter values. When you drop the class on a project, you can choose between adding the class or creating a subclass.

See Guidelines for Using Visual FoxPro Foundation Classes for more information on using foundation classes.

Properties, Events, Methods Description
cOutfile property The name of the output file.
Default: xtabquery
lCursorOnly property Specifies whether the input datasource is cursor.
Default: .T.
lCloseTable property Specifies whether to close the source datasource after the cross tab is generated.
Default: .T.
lShowThem property Specifies whether to show thermometer during cross tab generation.
Default: .T.
nRowField property Specifies the field position in the datasource of the cross tab rows.
Default: 1
nColField property Species the field position in the datasource of the cross tab columns.
Default: 2
nDataField property Specifies the field position in the datasource of the cross tab data.
Default: 3
lTotalRows property Specifies whether to total rows in the cross tab output.
Default: .F.
nTotalOption property Specifies the Totaling option to perform 0 = sum
1 = count
2 = % of total.
Default: 0
lDisplayNulls property Specifies whether to display null values in the cross tab output.
Default: .F.
lBrowseAfter property Specifies whether to open a Browse window on the cross tab output.
Default: .T.
RunXtab method Generates a cross tab.
Syntax: RunXtab( )
Return: none
Arguments: none