Pivot Table Foundation Class

Category Automation
Default Catalog Visual FoxPro Catalog\Foundation Classes\Automation
Class pivottable
Base Class Custom
Class Library pivtable.vcx
Parent Class automation
Sample ...\Samples\Solution\Ffc\Automate.scx

Remarks

This Custom class uses the PivotTable Wizard engine to generate an Excel Pivot Table from FoxPro data.

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 cPivFldCol, cPivFldRow, cPivFldPage, cPivFldData, lHasColumnTotals, and lHasRowTotals 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
CheckState property Specifies whether to test the state of
Microsoft Excel through an error routine.
Default: .F.
cOutfile property Specifies the name of the output file.
Default: ""
cPivFldCol property Specifies the name of the field that
identifies each pivot table column.
Default: ""
cPivFldData property Specifies the name of the field reported
as pivot table data.
Default: ""
cPivFldPage property Specifies the name of the field that
determines the pivot table pages.
Default: ""
cPivFldRow property Specifies the name of the field whose
values identify each pivot table row.
Default: ""
lHasColumnTotals property Specifies whether to total columns.
Default: .F.
lHasRowTotals property Specifies whether to total rows.
Default: .F.
nAction property Specifies the output action to perform.
Output action:
1 = Microsoft Excel worksheet
2 = Visual FoxPro form

Default: 1

GetXLPath method Queries the registry for the existence of
Microsoft Excel.
Syntax: GetXLPath( )
Return: none
Arguments: none
MSQueryCheck method Queries the registry for the existence of
MS Query.
Syntax: MSQueryCheck( )
Return: none
Arguments: none
PivotOutput method Creates a Microsoft Excel pivot table
output.
Syntax: PivotOutput( )
Return: none
Arguments: none
aFldList[1,1] property Internal to the class.
cFormName property Internal to the class.
cFormSCX property Internal to the class.
CheckFldLen method Internal to the class.
GetDOSName method Internal to the class.
lHasMSQry32 property Internal to the class.
lHasNoTask property Internal to the class.
lIsNumeric property Internal to the class.
SkipError property Internal to the class.

See Also

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