Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flatten a child table (many in a 1-to-many), efficiently
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Firebird
Application:
Desktop
Miscellaneous
Thread ID:
01410090
Message ID:
01410218
Views:
36
>>>Did you try running FastXTab against one of your tables?

Yes, I think I have my expected results in the Cross Tabs, bit different from what I had thought, but just might be doable. The column is based on cCode, row I made it to be iInvoiceID, data on bAmt. I think I can repeat this for nPerc and iAccountID into different cursors and probably can achieve the reporting. Thanks a lot.

>No, it's just becase for me Cross-tab and FastXTab are interchangable words :)

:)
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform