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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.