Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Print a Form
Message
De
30/07/1997 12:28:10
 
 
À
30/07/1997 08:46:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00041841
Message ID:
00042377
Vues:
34
Hi Billy! There is only way to do this hardest thing. 1. Make cursor Tmp that contains all field from Table A,B,C 2. Scan table A and count records in tables B and C You'll have table looks like: RecfromA CntFromB cntFromC 1 2 1 2 3 2 etc 3. Scan table A again and add in cursor Tmp the maximum amount of record from table mentioned in step 2 for each record in A. 4. Fill cursor with all necessary data from all tables (A,B,C) 5. Make report one-to-many style. HTH Have a happy day Vladimir Shevchenko P.S. Or try another reporting engine ;) > >to printer. You can do it with method CaptureScreen of Sysinfo class > >that available on UT > Thanks for the advice. I decide to make a report but now I have another > problem. I have 3 tables (A,B,C for example). A has one-to-many > relationships to both B and C. I know how to do a report on one one-to-many > relationship but how can I do on two?
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform