Multiple tables data Inside of RDLC List control

Question

Hi,   

       I have developed payroll application (C# winform) with RDLC report. I generated the payslip using List control of RDLC to distribute payslip to every employee. But I can’t include the other table details with List control. The Timesheet and allowance table details may vary for each employee.

• I did't bind the dataset with tables
• Am using tableAdapter to select records and Programmatically assigning Dataset to reports. I am having lot of dynamic condtions on sql query

I have used three following tables

DTpayslip ( salID,empId,Datefrom,DateTo ,ect.. )

DTtimeSheet (SlNo, empID,Attend_Date, TimeIn, TimeOut)

DTallow _table (salID, empID, allowanceName, amount)

 

 My Current RDLC design

 

Dataset

 

Expected