Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grandfather/Parent/Child Report?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00199814
Message ID:
00200074
Views:
61
I see from your last messages that you solved the problem. However, in a future report you might think of using a cursor which has the necessary fields from all 3 tables in every record. No relations, no skips, just a single cursor that prints every record in the report. Use the Order clause so your Group Headers/Footers come out correctly and you don't even need an index.

Barbara

>I have a grandfather table with one child. This child is the parent of two child tables. I need one report that will show me all records from all tables. I have not been able to make such a report. Regardless of the setting of the OneToMany property for the relations, I cannot get all of the "grandchildren's" records to be printed. According the documentation, relationships such as these should be built in the init event of the data environment using set skip. I have tried this as well, to no avail. Does anyone have any idea what I might be doing wrong? Thanks for your time.
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform