General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only