Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Total Value on a 2-band report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178103
Message ID:
01178533
Views:
16
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform