Thanks Nadya

I have been meaning to give that program in downloads a go next time I do an xtab.

It sounds excellent .


>Hi Mark,
>
>Alexander placed in Downloads section file #9944, which works much much faster than VFPXTab. I made few modifications in this program to support totaling option. It still could be improved a little bit, but I would suggest MS to take a look at this algorithm instead of the one, used in VFPXTab...
>
>BTW, Valdis Matison has a similar program with even more options...
>
>>John
>>
>>I have to disagree
>>
>>Excel does this job much faster. Perhaps you are factoring in the time it takes to load Excel and are only running on small tables.
>>
>>For large tables it is better to uses anything other than VFPXTAB
>>
>>
>>>A particular case?? The cross-tabulation of data is a fairly generic process. I can't imagine a factor that would make a particular case unique. Perhaps the size of data. Then again, this would go back to the core design of the base program that would be useful in all situations.
>>>
>>>Sorry Alexander, I can't agree with your conclusion especially since you have offered no benchmarks to support your conclusion. To say that the program that ships with VFP cannot be slower is a conclusion that simply has no basis. I have used VFPXTAB on many occasions. I have also used Excel via automation for these tasks. Of the two, I'll take the VFP solution.
>>>
>>>
>>>
>>>
>>>>Hi!
>>>>
>>>>>How about the one that ships with the product? VFPXTAB.PRG???
>>>>
>>>>It's as slow as only possible. Write your own program for particular case.
>>>>It not very difficult but will be much faster.
>>>>
>>>>Alexander