>>>>I want to generate a cursor containing the result of the pivot table wizard programmatically. What are the exact syntax to do this? TIA
>>
>>There is also a Pivot Table class in the _FFC that you may glean some ideas from, or heck, even use as is.
>>
>>BOb
>
>Good point BOb, I should have mentioned I am still on VFP5.

Jose,
look at VFPXTAB.prg that ships with VFP5 - read the comments at the beginning
it explains all the parameters you can pass to it
If I am not mistaken that's pretty much the same class you have in the FFC only in the FFC it is stored in a VCX rather than a prg

IAC, you will probably see it is faster to create your own pivot tables (usign 2 SCANs etc.) if you know the particulars about your data (so you don't have to use the generalized solution in vfpxtab)

Arnon