Visual FoxPro Matrix Layout

Question

Hi there,

I got stucked in creating a matrix out of variables, out of a Mamut database. Mamut uses VFP to print orders, invoices, etc.

This is the situation.
With Mamut software you can create an article with variants, when creating an order, for example: Main article Shoe, Color: red, with variant: Size 3.

My question is how to create a table with VFP with the ordered variants categorized in columns like this:

                       Size 1 | Size 2 | Size 3 | Size 4 | Total
Main Article 1 |    5     |    4     |    10   |    0     |   19
-------------------------------------------------------------
Main Article 2 |    0     |    0     |     5    |   25    |   30
-------------------------------------------------------------
Main Article 3 |    2     |   40    |     8    |    0     |   50

I don't know how to separate the variant from the main article and put them in a column. In the normal view, VFP puts the Variants under the main-article.
Some help in the good direction would be very helpfull!

Thanks in advance!

Solidino

Answer 1

I wonder if what you're looking for is a crosstab. Take a look at VFPXTAB.PRG in the main VFP folder.

Tamar

Answer 2

This work will do the Pivot table Wizard in VFP. (The latest source is here: http://vfpx.codeplex.com/wikipage?title=XSource)

Another (and faster) options: http://fox.wikis.com/wc.dll?Fox~MatXtab~Wiki, http://fox.wikis.com/wc.dll?Fox~CrossTab~Wiki

You may also read this document: http://hectorcorrea.com/downloads/correapivottableswhitepaper.pdf