Skip to Content
Former Member
Jul 31, 2008 at 12:28 PM

Parent table with two child tables - how to show?


In my database (MS SQL) I have table structure where a parent table has two child tables (This is kind of like a invoice would have invoice lines, only the invoice lines are in two distinct tables - one for items, another for services). I want to display this on a crystal report, where as I would see the header details up the top, then one of the child tables as a grid (which a total, etc) and then the other child's tables (again as a grid).

How would I do this within crystal reports? Most of the examples I have come across assume this sort of report is based on a parent table with a single child table.