Share via


Cross Tab Foundation Class

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

Remarks

This class uses 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

See Also

Guidelines for Using Visual FoxPro Foundation Classes | Visual FoxPro Foundation Classes A-Z | Visual FoxPro Foundation Class Samples