>>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
Dear Cetin
Thanks for guidance, I have read that file named vfpxtab.prg that file take Row field , and a column field and a data field as input, but in my requirment in want to pass 2 or more than two columns as data field, can u help me in this regard,,
Shahid Saleem
Shahid