Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
YAQ on Multiple-Detail band report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01179392
Message ID:
01179484
Views:
13
You may be making the same mistake that I keep seeing people make with multiple detail bands. If all you have is one parent record ... and then another table with child records ... you do NOT have a situation for multiple detail bands. What you should be doing is driving the report with the child table and have a relation to the parent table. Create a data group on the field that matches up with the parent. Put all the parent information in the data group header band. Put all the child information in the detail band. No need for a second detail band.

Two detail bands are meant to be used in the situation where you have 3 tables .. a parent table, a child table, and a completely different child table. For example, a Customer table would be the parent and its information is placed in a Data Group Header band. An Order table would be the first child table showing all the orders from a customer and its information is stored in the Detail 1 Band. A Payment table would be the second child table show all the payments from a customer and its data is stored in the Detail 2 Band. There isn't necessarily a relationship between ORDERS and PAYMENTS.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform