Alex,
Yes, Pivot Tables are cooool! In my previous job I used to convert SAP reports into Pivot Tables on the fly. Users were just amazed by what you can do with Pivot Tables. It takes only about 15 minutes to train a new user. After that, they can use any PT. As you mentioned, there are still many Excel power users that don't even know about it. Another cool feature in Excel is auto filters. Depending on the data, I sometimes convert result sets into an Excel sheet with auto filters. The combination of VFP and Excel is really powerful.

Unfortunately, Excel doesn't handle large data sets very well. After all, it's not an RDBMS. Does anyone know about a similar tool that can handle large record sets? Has anyone used the OLAP tools of SQL Server with VFP?

Thanks.
>The Fox Rocks!
>
>And it does not hurt that it made another point with the boss for its power at data munging and producing results.
>
>I demoed it and not only were they impressed with the Pivot Table (they use Excel but not many people has seen/used a PV), but they were impressed when they saw that the VFP program gathered the last 30 days worth of data, munged it, summarized it and created an Excel PV on the fly, from a 500,000 record table in under 25 seconds!
>
>It never hurts to show VFP like this in a small corporation like the one I work for {BG}
>
>>>>>>>>>>>>>>
>>Alex;
>>
>>Good going! I think if you stuck with SQL Select statements you would still be trying to solve the problem. Helps to "think outside of the box".
>>
>>Tom
>>>>>>>>>>>>>>