How to set DataSource for RDLC Report using Report Viewer in C#

By FoxLearn 8/1/2024 2:31:19 AM   612
To set up a DataSource for a local report using the ReportViewer control in a C# Windows Forms application, you can follow these steps.

To play the demo, You should create a new dataset, then add a new table to your dataset.

This process involves creating a local report, configuring the DataSource, and binding it to the ReportViewer control.

To set data source for the local report at run time you can write your code as shown below

ReportData data = ReportData();//ReportData is a dataset
//If your report needs parameters, they need to be set
ReportParameter[] parameters = new ReportParameter[...];
ReportDataSource reportDataSource = new ReportDataSource();
//Must match the DataSource in the RDLC
reportDataSource.Name = "ReportData"; 
reportDataSource.Value = data.Customer; //Your table in ReportData
// Add any parameters to the collection
reportViewer1.LocalReport.SetParameters(parameters); 
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();

You need to create a ReportDataSource, then set data to the Value property - e.g. DataTable and IEnumerables are supported sources.