>Cetin,
>
>OK, have you taken a look at this product? I've heard good things about this product on Ed Leafe's Profox email list. I believe the vendor offers a free evaluation version for you to test as well.
>
>
http://www.contourcomponents.com/contourcube.htm>
>You can search the Profox archives via:
>
http://leafe.com/archives/search/profox>
>Some questions:
>
>1. How much data do you have to manage in terms of records?
>
>2. How many levels deep do you need to go?
>
>3. Do you just want your users to navigate your data or do you want them to edit and print from your data views as well?
>
>4. Is there some specific feature of Excel that you needed or can you use a VFP based solution?
>
>Malcolm
Malcolm,
Thanks for the info. It doesn't fit my needs (not searching for an activex control, I need to do that in Excel).
1) Who ever knows:) For a single table it might be 10-20K records. Different at levels though (ie: seconds level supposedly under 1K, 3rd even under 100).
2) Not much. 3-4 on average 7-8 at max.
3) I don't care what they do once I give them in Excel. IOW this is an export to excel.
4) I already have VFP based solution ready + some others like pdf, htm. It's excel now the bottleneck.
Let me tell you where the problem stems. Before VFP9 life was nice, I was collecting all data into a single cursor, and exporting it to excel or pivoting was easy. Now I've added new reports to system where I use multiple detail bands. On VFP side everything is working nicely. My export button was presenting a list of destination options and exporting from single cursors in a generic routine. Now with multiple cursors exporting got complex:) My users unfortunately are accustomed to fast response times from existing versions I can't just do time consuming exports. I could do this with multiple clipboard or ADO transfers but it'd be slow (honestly didn't get into speed comparison part yet). If I knew all customers had 2003 and up I'd play with XMLMappings. I'll spare some time checking ADOMD and OLAP. Hope I wouldn't end up combining all those cursors into a single one export as I do before (whatever I do should also be fast as going with this approach and you know VFP is fast in doing that - just wanted to give users a more intuitive interface in excel:). Excel has grouping at least but it's slow. There should be a way (looks like a pivot but I don't have anything to put into data area or columns area - just think multiple relational data or left side of a pivot. Might I be missing a feature that's possible with Pivots? I'll check that too).
Cetin