Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Detail
Message
From
25/10/2001 16:33:52
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00572364
Message ID:
00573390
Views:
19
Chad...

>Do I have to resort to Crystal Reports?<

No, you don't. The following is one way to overcome this problem...

1. Add a memo field (one for each child table) to the main/parent reporting table.
2. Using SET ALTERNATE TO or VFP's textmerge to create an ASCII text file of
the child data in the layout of your choice (including column headers).
3. Load the memo field(s) with the respective child data using eg. APPEND MEMO mChild1 FROM TextFile.txt.
4. Create a stretchable area on your report form for each child table, with the corresponding memo field as the controlsource for each. If you want the child columns aligned correctly, you will probably have to use a non-proportional font such as Courier New.

Hope this makes sense. Let me know if you wish me to elaborate further.

Regards,
Alan
Previous
Reply
Map
View

Click here to load this message in the networking platform