>I am having trouble creating a pivot table programmatically - I can do it interactively, but I am using data from a view and when i call up the builder, it doesn't allow me to select a view, only tables.
>
>One more problem - i get a "must use a shared database" message (along with the other error messages....!) and for the life of me I don't think the the database is set to be exclusive, although some tables may be..
>
>any help would be appreciated!
>
>michael
Michael,
You're using FFC wizard as I can understand. You could save your data as xls, open it in excel and pivot. IMHO it's not slower then using FFC and you have freedom. If you want to test it, the sample code is in a thread posted friday or saturday. As far as I remember title was something like "page totals in excel". Code uses Excel97 as target but compatible with VFP5-6 (no reason for it to be incompatible with VFP3).
Cetin