i have two table in sql DB named as Rsector and Psector,Rsector link with psector via forign key ,
i have created two dataset in rdlc, now using following code i am getting the values
rssreport = _service.GetRouteSectorStatusByNewRoute_Id(route).Where(x => x.RouteSectorStatusDate == dt).ToList(); foreach (var rssr in rssreport) { var emp = _service.GetAllEmployee().Where(x => x.Id == rssr.Employee_Id).FirstOrDefault(); dataset.RouteStw.Rows.Add( rssr.RouteSectorName, emp.Name, emp.Id, emp.CellNo, rssr.SectorName ); var rtpnt = _service.GetRoutePointStatusByNewRoute_Id(route).Where(x => x.RouteSector_Id == rssr.RouteSector_Id && x.Date == dt && x.NewRoute_Id==route).ToList(); foreach (var rps in rtpnt) { var emp1 = _service.GetAllEmployee().Where(x => x.Id == rps.Employee_Id).FirstOrDefault(); dataset.RoutePoint.Rows.Add( rps.AddRoutePointName, emp1.Name, emp1.Id, emp1.CellNo, rps.SectorName ); } } and output is as follow,RSname empid cellNo sectorand my requirment is
sss 12 mmm dd
fff 13 mmm ff
eee 14 mmm gg
AND Point
pntName empid cellno sector
www 43 vvv 1
wer 22 rrr 1
ttt 12 ggg 1
RSname empid cellNo sectormean first details of one sector then point of that sector,
sss 12 mmm dd
pntName empid cellno sector
www 43 vvv 1
wer 22 rrr 1
ttt 12 ggg 1
then second sector then point of second sector

Replies
Know the answer? Post it — somebody with the same question will find it here.