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?