Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Detail Band on a Report
Message
 
To
14/11/2000 03:51:26
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00441477
Message ID:
00441539
Views:
12
Not quite sure what your asking, but when people say multiple detail bands I believe they are talking about a parent\child relationship in a report. It has been a very long time since I've done this because I have stopped using the Report Writer in favor manually genereating HTML instead, but here are few ideas that comI've pulled from memory:

One way you can do this is by setting up 1 to many relations using the SET SKIP command. In the report, put your child fields side by side and group on the parent.

Another way is to create cursors that join to their associated child tables and UNION the individual queries together. You also have to add an additional field that identifies the source table that you'll group on.

Hopefully this is enough to get you started. You'll most likely have to add some Print When conditions as well.

Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform