Automate Pivot wizard

[ikh]

I have a crosstab table that I would like to show on the form by automating pivot wizard. Can anybody provide some examples of how to automate pivot wizard?
Thank you.

 

[darrellblackhawk]

Maybe this will help you get started...

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarfoxgen/html/msdn_vfp3wiz.asp

 

[ikh]

Thanks. I found pivtable.vcx class but cannot make it to work properly with form (I want to show pivot table on form).

 

[darrellblackhawk]

I haven't played a lot with the pivtable.vcx class,
but it creates the pivot table in Excel. There is a
provision in the wizard to create an embedded pivot table
on a form.

I'm not sure, but if you want it in a form; and fast, you
may have to construct a pivot table yourself (easy in SQL
Server, Oracle, etc.; more difficult in VFP) and then
display the results in some widget on a form.

Also, it's really slow, so creating it yourself
maybe the best approach.


Darrell