Hi, I am stuck up with a difficult situation. I have a rdlc report with a table within it. I need to bind two different datasources within the details section. I bind one detail section to one dataset and for another detail section, I put a subreport which processes my other dataset. But these two datasets are related, so it's basically something like display all, CustomerName and Number in 1st dataset and Order details within the second dataset. I am not able to related these two datasets. when I run my report, all of the order details repeat for every customer? I am using Linq2Sql to get my datasets. Any help is appreciated.

Try using an SSIS package as your data source. It will combine the sources for you to be consumed in a single dataset in SSRS.My Blog "Karl Beran's BI Mumble"

Hi ssrsdev, Since these two datasets are related, you can define a report parameter in the subreport, then on the main report, in the subreport parameter page, point the field which has relationship with the subsreport parameter to the subreport parameter. thanks, Jerry