>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