Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Child Table in multiple detail band printing twice
Message
 
À
23/01/2006 00:06:40
Sonny Tabano
Trams Printwork, Inc.
Mabalacat, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01089273
Message ID:
01089340
Vues:
10
What you have explained is a parent/child relationship which is not what a multiple detail band is meant for. It's meant for parent + child1 + child2.

In your situation, create a relation between parent and child and use SET SKIP.
SELECT Parent
SET RELATION TO SomeID INTO Child
SET SKIP TO Child
REPORT FORM Whatever
On the report, create a data group on the parent ID field. Place the parent information in the Group Header band. Place the child information in the detail band. Do not fill in the "target alias" in the detail band.

As far as your question about printing the parent and child information side by side .. the answer is you can't define the report this way. If you want to do this, you will need to create a temporary cursor that has both the parent and child information in each record and then drive the report from the temporary cursor and place all information in the detail band.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform