Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple detail bands
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01144761
Message ID:
01144886
Views:
18
Create a data group for the parent and put those fields in the data group header band. Detail 1 band should have target alias of adeduc and contain all those fields. Detail 2 band should have target alias of alot and contain those fields. Make sure the parent table is the current table when the report is run .. or if you are using the dataenvironment, make sure the parent table is the initial selected alias.




>Please help...
>
>In my report I have three detail lines. Parent table = "aporg" and then 2 detail tables "adeduc" and "alot". The table "alot" is the target alias for detail 2. In detail 2 band, I have a header/footer, but as soon as the detail band 2 header starts on a new page, then it only prints one detail line in the detail band 2. Relationship: aporg.ph_accno = adeduc.ph_accno and aporg.ph_accno = alot.ph_accno.
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
Reply
Map
View

Click here to load this message in the networking platform