>Dear All
>
>I want to cross tab more that one field (transform),Can i do this in vfp 5 if so how Can i do this...?
>e.g
>Table struture
>
>area_id, product_id, sale, target
>---------------------------------
>1 A 1200 1400
>2 B 1000 1200
>3 C 5600 4000
>4 D 2000 1000
>
>I want to convert the product_id to columns and the data against this, if have to use it again and again, can anybody help me in this regard.
>
>Thanks
>
>Shahid Saleem
Check vfpxtab.prg. Also you can design a query and set the destination to cross tab then view SQL to see what VFP calls for Cross Tabbing.
Cetin