Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parent - Child reports
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00843436
Message ID:
00843518
Views:
21
>What is the most flexible way to produce a report from tables in parent-child relation? In other words, if I have a parent table and several related child tables on a common key, what is best way to show them all in same report?

Charlie,

Off the top, I can think of a couple of ways. One would be to join the tables on the key and the resulting record set would include every child record. Another way would be to insert a subreport into the main report, where the subreport would be the child table and the link between the 2 reports would be the common key.

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform