Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Control Groups
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00805464
Message ID:
00805477
Views:
28
The only way to print multiple detail bands is to fudge the data. You have to fill a cursor with the information from the first detail band, marking a field as "1". Then fill the cursor with fields for the second detail band, marking those records with a "2". If you have a third detail band, continue in the same manner.

Once you have the data sitting in one cursor, you can design the report by putting all the fields for the first detail band on the report and set the "Print When" logic of all those fields to REC_TYPE = "1". Then add all the fields for the 2nd detail band, setting the Print When logic to REC_TYPE = "2".

You have to put all the fields for the 2nd detail band on top of the first detail band fields and it gets real ugly real fast. One trick I use is to design the first detail band and then lasso all the objects and then select Format | Group to keep them together. Then fire up a dummy report and layout out all the fields for the 2nd detail band, lasso them, group them together, and then cut and paste them to the real report.

Cathy


>Hi,
>
>I've got a customer that has a unique need.
>
>She wants a report with 3 sections of detail records on the same page.
>
>The main grouping is on a list of employees.
>
>There also needs to be two other sections that can contain multiple items, for example a TO section in which there can be multiple receipients and an attention section that can also have multiple items.
>
>Is this possible?
>
>Thanks,
>
>Dennis
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