>>I need to create a report that needs to have multiple columns
>>crosstabed. The GenxTab program included with Foxpro supports
>>only three fields: column, row and cell value. I will have
>>multiple columns (up to 6) in addition to the row and cell values.
>>
>>For instance the simple report that can be handled by VFP would
>>appear as such:
>>
>> Month stayed1 stayed2 stayed3 etc
>> Jan-98 12 15 22 ...
>> Feb-98 88 99 120 ...
>>
>>
>>Now in addition to the month column I need to reveal the
>>owner, domestic/international, site, card type, etc...
>>
>>Is there a modified version of genxtab that I can use to do this
>>or is there a better approach? I need this process to be very
>>dynamic. For instance, I may or may not need to group by
>>domestic/international but could show the column as ALL territories.
>>
>>Anyone done something like this before? I have searched the files
>>and Knowledgebase sections of the UT to no avail...
>
>There are a few work arounds.
>1) Besides grouping by month,owner, domestic/international, site, card type, etc... add a field as Id to SQL. Use Id as the "row".
>2) There was matxtab.prg for FP2.x (so should work uncahnged in VFP) by Valdis Matison (Matison corp.?). It was a replacement to genxtab.prg
>3) If excel exists create a pivot table.
>4) Modify the vfpxtab.prg to your taste.
>5) Create your own xtab.
>...
>Cetin

Hi Cetin,

Or use EXCEL. It's much more flexible. I've taken an example you left here in March and it works beautiffuly. I'm only stuck by one thing and I left a message in another section for that.

José