Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One to many report
Message
De
15/10/2000 17:19:19
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00429609
Message ID:
00429617
Vues:
23
>I'm designing a report that involves a one-to-many relationship. It prints out the contents of my check register. Some checks have more than one expense category (the many part of the relationship).
>When I run the report, only the first record of the child table prints. What am I doing wrong.

You need to drive the report off the child records rather than the parent; you group by the parent key.

Even better, cureate a cursor thatcombines the child records with their parent record fields, and just run the report against that cursor, eliminating the worry about who drives what.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform