Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple Detail
Message
De
23/10/2001 18:57:21
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Divers
Thread ID:
00572364
Message ID:
00572369
Vues:
20
>I'm wanting to have multiple detail sections of a report in VFP 6. That is, one parent table with several child tables at the same level, generating section A detail, then section B detail...
>
>I don't feel Unioned Selects (Q119354 Knowledge Base) would work because the structures are different among the child tables.
>
>Apparently this can be done in Access with "Sub Reports". Do I have to resort to Crystal Reports?

No you don't have to resort Crystal. VFP can't do multiple detail bands however it doesn't need to know actually you're doing multiple bands.
All it cares is you have to have total number of records as your detail lines.
You also don't need a union. If applicable you could of course create a union filling nonmatching fields with dummy values.
Create one dummy cursor as the report controller, relate it to multiple tables and use print when.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform