Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Flatten a child table (many in a 1-to-many), efficiently
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Firebird
Application:
Desktop
Divers
Thread ID:
01410090
Message ID:
01410211
Vues:
31
>>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
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform