Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Total Value on a 2-band report
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01178103
Message ID:
01178533
Vues:
17
>>The Band1 is the P.O. Header and Band2 is P.O. Items. So the report shows one line for the P.O. header info (Vendor, Dates, Total Amount) and then a bunch of items. Then at the bottom it is supposed to summarize the P.O. Amount column. Am I more clear now?
>
>
>What you are explaining above is not what multiple detail bands are supposed to be used for. If all you have is a parent (PO Header) and some children (PO Items) you don't need two detail bands. You should create a data group on the PO Number and but the PO Header information in the Data Group Header band. The PO Items information should go in the detail band. Do not fill in the Target Alias on the detail band. Instead, set a relation between the PO Header and the PO Line Items and just let the PO Line Items drive the report. That's it .. no multiple detail bands required.

As I mentioned in another message, the report already has a data group (e.g. P.O. vendors). I realized I could have two data groups. But the reason I don't want to use P.O. Header as a group is the following. When using Group By you are "limited" to what fields will be included (I am sure you know that). Whereas when you simply select records from the P.O. header table you can do it with POHEADER*. and all fields will be included. Do you see what I mean?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform