i am tried lot of times to bind the dataset to RDLC Report ,.. in my dashboard having three Report viewer and each have one report1,2,3 etc ,.. invoice ,salesorderand quote
invoice only bind and get output but remain two reports getting error ="database instance has not be supplied for the datasource 'dataset1'"
dsreportinvoice.Tables.Add(objservice.WBdownloadTransorder("N", "I", "BB"));
dsreportsalesorder.Tables.Add(objservice.WBdownloadTransorder("N", "S", "BB"));
dsreportquote.Tables.Add(objservice.WBdownloadTransorder("N", "4", "BB"));
DataSet ds = objCustomerDetailsBAL.GetSPCodeBAL();
CMBSO.DataSource = ds.Tables[0];
CMBSO.DisplayMember = "EmployeeCode";
CMBINV.DataSource = ds.Tables[0];
CMBINV.DisplayMember = "EmployeeCode";
CMBQ.DataSource = ds.Tables[0];
CMBQ.DisplayMember = "EmployeeCode";
string reportPathinvoice = @"D:\WORKING_FOLDER\ISELLIT\ISELLIT\Report1.rdlc";
string reportPathSalesOrder = @"D:\WORKING_FOLDER\ISELLIT\ISELLIT\Report2.rdlc";
string reportPathQuote = @"D:\WORKING_FOLDER\ISELLIT\ISELLIT\Report3.rdlc";
RPTVinvoice.LocalReport.DataSources.Add(new ReportDataSource("Invoiceorder", dsreportinvoice.Tables[0]));
RPTVinvoice.LocalReport.ReportPath = reportPathinvoice;
this.RPTVinvoice.RefreshReport();
RPTVsalesorder.LocalReport.DataSources.Clear();
RPTVsalesorder.LocalReport.DataSources.Add(new ReportDataSource("Invoiceorder", dsreportsalesorder.Tables[0]));
RPTVsalesorder.LocalReport.ReportPath = reportPathSalesOrder;
this.RPTVsalesorder.RefreshReport();
RPTVQuote.LocalReport.DataSources.Clear();
RPTVQuote.LocalReport.DataSources.Add(new ReportDataSource("Invoiceorder", dsreportquote.Tables[0]));
RPTVQuote.LocalReport.ReportPath = reportPathQuote;
this.RPTVQuote.RefreshReport();