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:
01410211
Views:
32
>>Just a thought. Can I cross tab individually on this InvoiceFooter based on the iAccountID, once for nPerc and another time for bAmt and maybe even for the cCode (JOINed). They will be one record each so there is no reason to co-ordinate the record pointer. That, if, done, I think I can do some manipulation in Report Manager for reporting.
>
>I believe you can cross-tab each individual table without a problem.

Just had come back to update my post to Sergey to say maybe not, when I saw your reply, cause we have multiple iAccountsID in multiple-rows with different bAmt for each iAccountID, is this possible?
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform