Master and two details?

Question

I've been searching all morning and this looks too difficult to be true.  I have a report that shows contact information.  The contact name info is the master record.  The contact may have many phone numbes and many addresses.  I'd like to get the rdlc slapped together to look like the following:

 

Surname	Given	Middle
Jones	Jimmy	B.
	Addresses
	123 Some Street (Home)
	909 Lake Road (Cottage)
	Phones
	555-1234 (Home)
	555-1244 (Cell)

 

If I only had the Name and Phone tables to worry about, I'd just flatten it out in the query and use the grouping to show it nicely, but it turns to total *** if I try to flatten out two 'detail' tables.  Suggestions?

Answer 1

 

Use subreport to display the details.

Answer 2

 

Well... upon testing out the denormalized data theory, it actually works properly.  I just get one big cartesian (sp?) product back and let the report grouping mechanism figure it out.  Works like a charm, as cheezy as it feels to code it.