Got Excel? If so, use Pivot tables. You can use VFP to automate the creation of these files. To get you started, try here:

http://hcorrea.no-ip.com/dotwiki/Default.aspx?topic=ProgrammingRubberBandReportsWithPivotTables

>Hi.
>I have an APP which each night/ week analyses data and sorts/consolidates the raw data into a data warehouse type structure . This is wriiten in VFP and it outputs numerous files , say by Customer, By product. By rep etc showing the data for each Month ,Quarter etc.
>
>What I dont have yet is a way to analyse this data and 'Present' it on screen in a 'Pretty' format, showing columnar data ,allowing a facility to Graph the data and print it,facility for total lines....
>
>I could re-invent the wheel but I am sure there are tools out there that do this.
>
>I'd be interested in experiences or information on tools that work with VFP8 data.
>
>
>Thanks in advance for any help.
>
>Regards,
>
>Gerard