Unable to attached data to subreport

Question

Hello everyone..

I'm trying to add subreport to MicrosoftReportViewer control.
I added the subreport control to the main report (reportViewer3) and created new report to attached to the subreport. Also I attached to the subreport a DataSource named "NetDataSet_ShowBookResForEachShop" that contain 2 fields: name, amount.
I also attache to the main report event (SubreportProcessingEventHandler) to handle the processing of the subreport.

The problem is thae even that the event working just fine (thisDt is a table contains 2 coulmns named: name & amount filled with data) I'm getting the error "Error: Subreport could not be shown" instead of the subreport itself.

I sure that somthing is missing but I can't fugure that out.

Attached code snap.

Thank's in advance for your help, 

Lior..
  

private void reportViewer3_Load(object sender, EventArgs e)

{

      reportViewer3.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportProcessingEventHandler);

      reportViewer3.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;

}

 

private void SubreportProcessingEventHandler(object sender, SubreportProcessingEventArgs e)

{

    SqlConnection thisConnection = new SqlConnection(localLookUp.Instance().ConnectionString);

 

    DataTable thisDt = new DataTable();

    thisDt =localLookUp.Instance().SearchDB("EXEC ShowBooksResForEachShop '3220618','1/1/1888'");

    e.DataSources.Add(new ReportDataSource("NetDataSet_ShowBooksResForEachShop", thisDt));

}