none
Master and two details? RRS feed

  • 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?

    Tuesday, April 15, 2008 5:42 PM

All replies

  •  

    Use subreport to display the details.
    Tuesday, April 15, 2008 8:24 PM
  •  

    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.
    Tuesday, April 15, 2008 9:35 PM