data not added to .rdlc report file, need help

Question

User1070938216 posted

i want to add the customer list to Report1.rdlc file,

what i did is, i added CustomerList.xsd file and added a DataTable to it

i filled that data table by the code written below, 

but the data is not shown to report, please help

try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
ds = cdobj.getCustomerListForDataset();
if (ds.Tables[0].Rows.Count > 0)
{

dt1 = ds.Tables[0];
DataRow drow;

CustomerList cl = new CustomerList();
//CustomerList cl =
cl.Tables["DataTable1"].Clear();
dt = cl.Tables["DataTable1"];
for (int i = 0; i < dt1.Rows.Count; i++)
{
drow = dt.NewRow();
drow[i] = dt1.Rows[i];
dt.Rows.Add(drow);
}
this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("test", cl));
}
this.reportViewer1.RefreshReport();
}
catch(Exception ex)
{
}
}

Answer 1

User765438783 posted

Hello Sanjay,

I am not sure, but I feel that you are adding all the rows to datatable dt, but not updating cl.

Finally, you need to update cl, because that is the datasource for the report.

Hope I gave some useful information.

 

Answer 2

User1070938216 posted

thank you krishna for your reply, but it's not working after updating cl also.......

i also tried like this.....

this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("test", dt));

Answer 3

User-1185172246 posted

A couple of things:

1. Is your app a Windows Forms one? Because I see Microsoft.Reporting.WinForms.ReportDataSource which refers to the Report Viewer win forms edition.

2. What is the exact name you set up for the data source in the RDLC report? If it is e.g. DataSet1 then you must use that name in this line:

this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", cl));

Otherwise reportviewer will not be able to do the binding.

Answer 4

User1070938216 posted

i got the problem, datatable dt is not being filled, thats why no data is shown to report