Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two Detail Band on the report is it possible
Message
De
14/11/1999 11:07:25
 
 
À
14/11/1999 10:56:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00291088
Message ID:
00291089
Vues:
31
>A report has one master table and two child tables.
>So a report must show multiple records from one child table on the separate group and multiple records from another childtable on separate group.
>
>The format will be something like below.
>
>Details about the Customer.
>
>Customer Name: xyx
>
>------Customer Branches---------
>Customer Branch 1 abc
>. bcd
>.
>Customer Branch n xyz
>--------------------------------------------
>-----------Customer Products Purchased------------------
>Customer Product 1 prod1
>. prod2
>.
>Customer Product n prodn

You should combine all data in one cursor where you will have a field (e.g. 'GroupId') to indicate where the record goes: either to branches or to products:
Mycursor:
CustomerId GroupId  BranchId BranchName.... ProductID ProductName....
1           1        1        'abc'         0          ''
1           1        2        'xyz'         0          ''
1           2        0        ''            1          'prod1'
1           2        0        ''            2          'prod2'
2           1        3        'pou'         0          ''
etc.
This cursor can be buiilt using UNION and /or SCAN.
Now, you can group you report by CustomerID+GroupID and use 'Print When' expression to print needed fields/labels in detail and group footer/header bands.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform