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