nested list with mutil-dataset

Hi, All,

I need to have a report with summary and details. The summray list is 'EmpolyeeID' and 'Name'. The details are 'emails' and 'phone numbers'. One Employee could have one or more emails, and one or more phone numbers.

The dataset are
1. select EmployeeID, Name from Empolyee
2. select EmployeeID, email from Emails where EmployeeID = @.ID
3. select EmployeeID, PhoneNumber from PhoneNumbers where EmployeeID = @.ID

I'd like to have one summary list with dataset 1. The list contains two nested lists, one for email, the other for phone numbers.

How to do it? Thanks!

-Zhining Zhang

Probably the easiest way is to create single flat dataset, then group top list by EmpoyeeID|||

1. I can use subreport, but I prefer nested list.

2. In msdn, http://msdn2.microsoft.com/en-us/library/ms157134.aspx, it is said

Nested Data Regions
You can nest data regions within other data regions. For example, if you want to create a sales record for each sales person in a database, you can create a list with text boxes and an image to display information about the employee, and then add table and chart data regions to show the employee's sales record.

Is there any sample?

Thanks!